Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    combine worksheets (2003)

    Is there a way to take a bunch of excel files, generally 1 sheet per file, and combine them into one files with multiple sheets? I'd also like to do this with tab-delimineted text files.

    I found the tip on putting a short cut into the templates folder, but I couldn't figure out how to do it...duh....

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: combine worksheets (2003)

    You can open a series of files (Excel workbooks, text files, ...) in Excel, and use the Window menu to arrange them within the Excel window. You can then drag the sheet tabs to one of the files (note: when you click in another window, the first click will only activate the window, you'll have then have to click on the sheet tab in order to drag it).

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: combine worksheets (2003)

    Thanks!

Posting Permissions

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