Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2002
    Location
    California, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combine multiple worksheets into one (2003)

    Hi, I was wondering if there is a quick way to combine worksheets, other than copy/paste.

    I have 30 worksheets in 4 different files that I need to put all on one page. If I import, it doesn't let me select multiple sheets. If I do combine it wants me to choose sum or some other function. I need all the data off of all the sheets. Each sheet is laid out the same, so copying/pasting would work but I just wondered if there was a quicker more efficient method. I have fairly basic excel skills, so writing macros etc. won't be quicker for me.

    Thanks for the help

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

    Re: Combine multiple worksheets into one (2003)

    If you want to create a single worksheet with all the data, you can either copy and paste, or you can arrange the source and destination windows so that both are visible, and drag a range from the source to the destination and drop it there. I don't think there are really faster ways without writing a macro (which would take more time anyway).

  3. #3
    Lounger
    Join Date
    May 2002
    Location
    California, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine multiple worksheets into one (2003)

    Thanks, I appreciate the quick answer!

Posting Permissions

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