I need to merge about 75 worksheets into one spreadsheet on a regular basis -
all have exactly the same format/layout etc back can vary in the number of
rows

Try this Jeff
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jeff224" wrote in message ...
I need to merge about 75 worksheets into one spreadsheet on a regular basis -
all have exactly the same format/layout etc back can vary in the number of
rows

Or
http://www.rondebruin.nl/copy2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Try this Jeff
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jeff224" wrote in message ...
I need to merge about 75 worksheets into one spreadsheet on a regular basis -
all have exactly the same format/layout etc back can vary in the number of
rows

Hi

could you explain what you mean by merge - are you adding them together or
appending them onto the same sheet.
are all 75 worksheets in the same book?
what is the structure of the sheet names?

Cheers
JulieD

"Jeff224" wrote in message
...
I need to merge about 75 worksheets into one spreadsheet on a regular
basis -
all have exactly the same format/layout etc back can vary in the number of
rows