ayeFayze wrote:
Thanks for your input. i had thought a fairly simple sub subRoutine could be
crafted to increment from an excel spreadsheet (1 column list) and loop thru
the process. that would NOT have completed the process but would have
eliminated much of the tedium and bought me time to learn and modify/improve
the structure. as i received this project, it had taken 3 weeks to finish
updating a single serial number. i have it down to 3 days, and want it down
to 3 minutes. old system & old software, but i know it can be done. i can tie
several macros together, but i have got to get to that list. i do appreciate
your help and consideration.
ayeFayze

Wouldn't it be faster just to input the data manually :-) 3 days!
Something is seriously wrong with the design. You should be able to
update all 1000 in about 3 seconds. What sort of data takes 3 days to
update for ONE serial number?

gls858