ExcelBanter - Merge two Excel files

You can copy an entire worksheet in one operation by selecting the whole
sheet. Click the box at the top left of the sheet(above 1 and left of A) to
select the sheet, copy, select A1 on a blank sheet in your other workbook
and paste. The only drawback with this is that any interactions between
sheets in the old book will point back to the olde book. The way round this
is to cut instead of copy.

Always make sure you back up both books before you start and save the
combined sheet under another name until you're sure it's OK.

--
Ian
--
"Teleinternnor"
wrote in message
news:Teleinternnor.1tpveg_1123959926.724@excelforu m-nospam.com...

i want to merge two excel workbooks into one but in seperate sheets. Any
idea as to how this can be done. dont want to copy paste again and
again. Please help me out.
Thanks

--
Teleinternnor
------------------------------------------------------------------------
Teleinternnor's Profile:
http://www.excelforum.com/member.php...o&userid=26263
View this thread: http://www.excelforum.com/showthread...hreadid=395585