Anyone know how to merge two spreadsheets into one? I have two seperate files I would like to merge into one.
Anyone know how to merge two spreadsheets into one? I have two seperate files I would like to merge into one.
Open both workbooks.
Select all the sheets (tabs) in workbook 1.
Right click on the tab(s)
Select "Move or copy ..."
In the "To Book" drop down, select the second workbook
Decide where in the second book you want the sheets to appear
Select "Create a copy"
Click OK
If you want to retain both the original workbooks as they were, make a copy of one of them first and use that as the target.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks