Hi there! Using E02 on XP. Not a programmer but have used
Access for awhile. However, this project can best be done
in Excel. I can do some code, mainly event procedure stuff
as well as formulas.

There are still a few Lotus 1-2-3 files at my company and
this one in particular runs a series of fund return
reports that can be printed or pasted into Excel files.
(One for each of five commission levels, data kinda spread
out in different cells, cause it looks cute to print.) I
also have the Excel file "shell" needed by systems as the
final product. (One worksheet, with five segments for the
commission levels; A1:H77; A122;H198; A243:H319;
A364:H440; and A485:H561.)

For years this poor dude has been printing the five
reports, eyeball comparing and hand correcting the "shell"
file before sending it to systems and I know there's got
to be a better way.

I think I know what to do but want to verify it in the
newsgroups before plowing in just in case there's a better
way I'm not seeing.

I'm guessing I recreate the "shell" on a new file on
worksheet one and paste in the generated file data to
worksheet two. Name my file. Then go to each cell on
worksheet one and make it equal the appropriate cell on
worksheet two. Since the file spitting out the reports is
Lotus 1-2-3, we don't have to worry about the data being
altered in any way because we don't even have technical
support for it anymore. And until someone reprograms the
whole thing in Excel (could be years), this is what we've
got. Then, each time I paste in new data to worksheet two,
worksheet one is automatically updated, correct? Then I
just select, copy and paste special/values, save and send
on it's merry way.

Looking forward to hearing from someone. Thanks in advance
for any help or advice! LUV U GUYS!