Hi Merlin

See this code example
http://www.rondebruin.nl/copy2.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Merlin" wrote in message ...
I have ten worksheets in one workbook and I need to combine the (10)
worksheets information into another worksheet. I do not want the totals from
each sheet to copy over. All columns are the same, however the number of
rows in each worksheet can vary each time the spreadsheet is used. Each
worksheet's data begins on row 11, the last row will vary.
Is there a way to automate the copying of the data from ten worksheets into
one?

Thanks in advance for the help!