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

with out seeing the sheet this is kinda hard for me, try somthing lik
this pardon my bad syntax

For i = 5 to 75
i=i+1
label(i).caption = cellletter & (i)

Next i


that will chuck all infomation ino a incrementing cell incrementin
down a column not to sure about the label comman but there is anothe
way around that. If you want more help my e-mail i
so send me a line an i will help you as muc
as i can..

--
Message posted from http://www.ExcelForum.com