+ Reply to Thread
Results 1 to 1 of 1

Consolidate and Merge Data on a Separate Sheet

  1. #1
    Forum Contributor
    Join Date
    07-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    123

    Consolidate and Merge Data on a Separate Sheet

    Trying to consolidate and Merge Data on a Separate Sheet. I think is for the more advanced only but will help others out as well as it's a very cool trick. Hope you can help.

  2. #2
    Registered User
    Join Date
    02-13-2013
    Location
    Rogers
    MS-Off Ver
    Excel 2007
    Posts
    46

    Re: Consolidate and Merge Data on a Separate Sheet

    I believe the attached will accomplish what you need done.

    *Edit: there seems to be a server crashing issue preventing the attachment actually attaching. The following formula should work for the balance column in sheet 2. You should be able to drag that over and down to capture the other totals you are looking to consolidate from the other tab.

    =SUMIF(Information!$A:$A,Sheet2!$C15,Information!B:B)
    Last edited by rlh06; 07-23-2014 at 04:22 PM.

+ 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. Macro Not working - Consolidate different sheet into 1 sheet and merge into 1 tab
    By gpcarthik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2014, 03:08 PM
  2. [SOLVED] Merge/Consolidate Multiple Workbooks data into a Single Sheet
    By COLIN_303 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-08-2012, 04:53 AM
  3. [SOLVED] Merge/Consolidate Multiple Timesheet data into a Single Sheet
    By dingbat in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-11-2012, 12:51 PM
  4. Merge / Consolidate data
    By jhayes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2007, 08:15 PM

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