Merging workbooks

  • Hi,
    I have two workbooks with a variable number of worksheets in each.
    I want to copy workbook 1 into workbook 2 (consolidating two workbooks into one, but keeping all worksheets independent).


    Thanks in advance for your help!

  • Re: Merging workbooks


    Hi,


    Since I don't suppose you'll be doing this repetitively you don't need a macro you just need help?


    Open both Workbooks. In one of them, <CTRL + click> on each of the sheets. They are now ALL selected. Click 'Edit, 'Move or Copy Sheet'.


    Select the Workbook to copy them to, select (move to end) or before 'Sheetname', check 'Create a copy' and then click 'OK'.


    If you didn't select 'New' in the 'Copy to', do a Save As. If you did choose 'New' - copy the sheets from the second workbook to the 'New' workbook and save it. Either way, you're done!


    Cheers,


    dr

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!