Thread: how to merge separate worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote