D
diverdon99
I have data in a number of worksheets within the same workbook and need to
place this data in a more user friendly way (possibly form) for the end user
to add additional information.
Maunually, I would create a form on the same sheet then copy and paste each
item of data into the correct cell inserting or deleting lines in my form as
needed.
With several hundred sheets I need to automate this to avoid losing the will
to live!
The core information contains a number of identical repeated items that only
need to be copied once. It may have from 5 to 75 rows in each sheet so the
form needs to be resized as required.
In Access this would be no problem but Excel has to be used as the sheets
will be emailed on.
Any ideas gratefully recieved.
Diverdon
place this data in a more user friendly way (possibly form) for the end user
to add additional information.
Maunually, I would create a form on the same sheet then copy and paste each
item of data into the correct cell inserting or deleting lines in my form as
needed.
With several hundred sheets I need to automate this to avoid losing the will
to live!
The core information contains a number of identical repeated items that only
need to be copied once. It may have from 5 to 75 rows in each sheet so the
form needs to be resized as required.
In Access this would be no problem but Excel has to be used as the sheets
will be emailed on.
Any ideas gratefully recieved.
Diverdon