Hi there
Last year I created an Appraisal form that we use at work for about 500 people. It's a Word protected form with form fields set in a number of seperate tables
For this year, I need to add a function that allows a user to open up last year's form, copy one table from it and paste the data into a different table in another copy of the same form
The table with the data in it is 4 columns wide but may have any number of rows in it. Row 2 onwards needs to be copied across
The table for the data to be pasted into is 6 columns wide and may not have enough rows to accommodate the pasted data so would need some sort of error trapping to pick up that it needs extra rows adding before pasting.
Data should be pasted into row 2 onwards and should sit within the first 4 columns of the receiving table. The idea is then the user fills in column 5 and 6 adding comments about the data they have pasted in
If any extra cells are needed to fit the incoming data they should have form fields in columns 5 and 6 too for entering the comments above
Phew...hope this makes sense
My experience of this kind of thing is limited to modifying other people's VB code/macros to add some functionality myself. This is a bit beyond me!
Last year I created an Appraisal form that we use at work for about 500 people. It's a Word protected form with form fields set in a number of seperate tables
For this year, I need to add a function that allows a user to open up last year's form, copy one table from it and paste the data into a different table in another copy of the same form
The table with the data in it is 4 columns wide but may have any number of rows in it. Row 2 onwards needs to be copied across
The table for the data to be pasted into is 6 columns wide and may not have enough rows to accommodate the pasted data so would need some sort of error trapping to pick up that it needs extra rows adding before pasting.
Data should be pasted into row 2 onwards and should sit within the first 4 columns of the receiving table. The idea is then the user fills in column 5 and 6 adding comments about the data they have pasted in
If any extra cells are needed to fit the incoming data they should have form fields in columns 5 and 6 too for entering the comments above
Phew...hope this makes sense
My experience of this kind of thing is limited to modifying other people's VB code/macros to add some functionality myself. This is a bit beyond me!