+ Reply to Thread
Results 1 to 2 of 2

Merging two spreadsheets

Hybrid View

  1. #1
    Registered User
    Join Date
    09-16-2010
    Location
    lincoln ne
    MS-Off Ver
    Excel 2003
    Posts
    1

    Merging two spreadsheets

    Anyone know how to merge two spreadsheets into one? I have two seperate files I would like to merge into one.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,179

    Re: Merging two spreadsheets

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1