Consolidate Data into one sheet

waseemsiddique

New Member
Joined
Sep 23, 2017
Messages
1
Hi Guys,

I have Trial Balances of different divisions with same pattern in many different sheet.
I have prepared a separate sheet which include the sum of certain codes of trial balance to make a profit & Loss A/C.
(As an example all codes in the Trial Balance in All sheet starting with Digit 40 are Sales Ledgers, and 5 are cost of sales to sum up the Total to prepare a Profit & Loss A/C).

Now I want if i could just filter in the same sheet by division name and i will automatically get the data from the relevant sheet.

3-D Reference could not be used as i don't need the sum rather i want to bring the whole TB value in that Master Sheet in predefined way.

I hope you will get my question :(
 

Forum statistics

Threads
1,084,889
Messages
5,380,446
Members
401,679
Latest member
saffar

Some videos you may like

This Week's Hot Topics

Top