Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2009
    Location
    Arizona
    Posts
    25
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Combine Excel spreadsheets

    I've searched through the first 10 pages to find an answer, to no avail. Simple question-I have 7 different, 1 page Excel spreadsheets that I want to place together into one workbook(with the 7 different pages). As these pages are financial info, I didn't want to chance this on my own. Am using Excel 2007. Any help greatly appreciated. Thank you.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Open all 7 workbooks. Right click one of the worksheets and select move or copy. In the "To book" select the name of one of the workbooks to move them all to (or choose new book to make a new one), then choose a location and hit ok. Repeat for each workbook. When done you should have one workbook with all the worksheets and none of the other books open.Steve

  3. #3
    Lounger
    Join Date
    Dec 2009
    Location
    Arizona
    Posts
    25
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Excel Combine

    Thank you very much.

Posting Permissions

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