How do I consolidate many sheets in same file to 1?
 

I have a workbook that contains 465 sheets. Each sheet has about 50 items. I
would like to append all to 1 worksheet to export.

How do I consolidate many sheets in same file to 1?
 

Hi IEW

See this page
http://www.rondebruin.nl/copy2.htm

--

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


"IEW" wrote in message ...
I have a workbook that contains 465 sheets. Each sheet has about 50 items. I
would like to append all to 1 worksheet to export.