+ Reply to Thread
Results 1 to 2 of 2

Combine data multiple tabs into one Summary Tab

  1. #1
    Registered User
    Join Date
    07-29-2011
    Location
    Mission Viejo, California
    MS-Off Ver
    Excel 2003
    Posts
    7

    Question Combine data multiple tabs into one Summary Tab

    I am making a log for a quality control area, there are multiple inspectors and they all have their own tab in the worksheet. I want to be able to take all the data from those tabs and consolidate it into another tab called "Summary". The data starts on row 10 and the all tabs have the same header including the summary tab. Also there is a summation line at around line 200 that I don't want to be copied into the summary tab, if it has to be removed that would be fine. The data is in columns A to Z. Any help would be greatly appreciated
    Thank you

    Here is the worksheet.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-29-2011
    Location
    Mission Viejo, California
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Combine data multiple tabs into one Summary Tab

    Is there any other way to do this? Is this too hard or not feasible?

+ 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