how to merge separate worksheet
 

"I need to merge about 500 separate worksheet (in separate workbooks) into
one worksheet. Is there any way to do this?
I'm looking for any ideas how best to do this. Any help is GREATLY
appreciated. All worksheets are identical in format and number of columns.

how to merge separate worksheet
 

Check out Ron de Bruin's Copy/Paste Merge pages.

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP

On Mon, 14 May 2007 17:33:01 -0700, Jane wrote:

"I need to merge about 500 separate worksheet (in separate workbooks) into
one worksheet. Is there any way to do this?
I'm looking for any ideas how best to do this. Any help is GREATLY
appreciated. All worksheets are identical in format and number of columns.