Combine Several Worksheets within a Workbook
 

I have a workbook that has 700 worksheets in it, a client would like me to
combine all the worksheets so they are on one. Each worksheet has anywhere
from 6 rows to 125 rows of information.

Is there a quick way via a macro, function or other excel feature, that I
could do this?

Combine Several Worksheets within a Workbook
 

Hi Erika

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


--

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




"Erika" wrote in message ...
I have a workbook that has 700 worksheets in it, a client would like me to
combine all the worksheets so they are on one. Each worksheet has anywhere
from 6 rows to 125 rows of information.

Is there a quick way via a macro, function or other excel feature, that I
could do this?