+ Reply to Thread
Results 1 to 6 of 6

Consolidate data from multiple sheets into one sheet

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    66

    Question Consolidate data from multiple sheets into one sheet

    Hi,

    I have received very quick responses for the queries I have placed and I am Very thankful of all of you. I am again stuck with a problem and would appreciate assistance...

    I have attached a spreadsheet which contains multiple sheets.

    Sheet 1, 2 & 3 are named as per agents i.e. A, B & C.
    Sheet 4 is where I require the end result which is consolidated data of the three sheets.
    I tried the option of multiple pivot range table but cannot get it correct.

    I am all ok with formulas as well....

    Thanks

    Adi.
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Consolidate data from multiple sheets into one sheet

    Hi Adi,

    IMO, I see a formula over a pivot table working out just fine...

    In C3 copied down and to the right...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    06-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Consolidate data from multiple sheets into one sheet

    Thankss Jeff.. that worked perfectly... however can you please help me understand the application of the "INDIRECT" function and the syntax "(ref_text,a1)" since I have never used it.... Thank you again for your response...

  4. #4
    Registered User
    Join Date
    06-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Consolidate data from multiple sheets into one sheet

    Also if you could change the reference from the names to the employee id... since its unique.... it would be very helpful. Thank you.

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Consolidate data from multiple sheets into one sheet

    You are very welcome and thanks for the feedback.

    For Indirect >> http://www.excelfunctions.net/Excel-...Functions.html

    Try...

    Please Login or Register  to view this content.
    Another great way to understand what a formula is doing...

    Evaluate Formula
    • Click on the cell with the formula >> Ribbon >> Formulas >> Formula Auditing >> Evaluate Formula
    Last edited by jeffreybrown; 08-02-2013 at 07:58 AM.

  6. #6
    Registered User
    Join Date
    06-07-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Consolidate data from multiple sheets into one sheet

    Simply Awesome.... Thank you verry Much for your help... Brilliant !!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need help with a macro to consolidate data from multiple sheets into one
    By xdskyline in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2013, 06:21 PM
  2. Pull Data from multiple sheets and consolidate.
    By edgarx50 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 07:47 PM
  3. Replies: 20
    Last Post: 10-19-2012, 04:35 PM
  4. Replies: 0
    Last Post: 09-05-2012, 11:57 AM
  5. [SOLVED] how do i use import to consolidate data from multiple sheets
    By Naveen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2006, 07:45 AM

Tags for this Thread

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