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

    Merge several identical sheets into one (Excel 2000)

    I have created a worksheet with 20 rows of employee names. This has been sent out and each employee was to fill in their appropriate row and return it. I have copied each of these returned worksheets into one file and would now like to compile all the information into a master sheet. Could anyone please tell me how to do this?

    Thanks..Susan

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

    Re: Merge several identical sheets into one (Excel 2000)

    If you had many more employees, or if you have to do this often, it would become worth while to think about a solution involving formulas or VBA code. With "only" 20 employees, it's probably fastest to copy each filled in row and paste it into the master sheet.

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Merge several identical sheets into one (Excel 2000)

    Would Data Consolidation work for you? Look under the Data menu.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge several identical sheets into one (Excel 2000)

    Thanks for your responses. I am not sure how data consolidation works. However, I did find a solution that worked. I used concat(sheet1A1+sheet2A1+sheet3A1)etc. and dragged for formula through the entire summary sheet.

    ..Susan

Posting Permissions

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