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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks