View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lilsis7
 
Posts: n/a
Default Merge worksheets from separate files into one workbook.



"dagriffin" wrote:

I have several single-worksheet Excel files/workbooks that I would like to
merge into a single file/workbook. Any idea how I can turn these into one?
Thx!


To do this, save one of the documents as your entire book, then, right
click on the bottom tab of the other documents you want to move, and hit move
or copy. on this selection at the top is an arrow, says move to book, arrow
down until you see the name of your new file. Make sure you click the box at
the bottom of the window that says make a copy so you won't loose your
original (unless you don't need it anymore) Do this with every file.