BBrittain12
New Member
- Joined
- Apr 21, 2016
- Messages
- 20
I have a spreadsheet that has 4 tabs (Year1, Year2, Year3 and Combined)
Within each tab is hours and dollar amounts in each column
The top row 1:1 sums all the information within the columns it is associated with
So column A2:A1000 Has Dollars
Column B2:B1000 has Hours
Column C2:C1000 can have one of four Areas (North, South, East, West)
Within each sheet i can filter by "Area" and see how that area did within that timeframe
Each sheet is built the exact same way, but the hours and dollars are different.
I have a final tab that is named "Combined" which adds up all the totals
What i want to do is be able to filter by area on the "Combined Tab" and it give me the totals throught the spreadsheet, instead of having to filter each sheet (Year1, Year2 and Year3) individually.
Can this be done?
Within each tab is hours and dollar amounts in each column
The top row 1:1 sums all the information within the columns it is associated with
So column A2:A1000 Has Dollars
Column B2:B1000 has Hours
Column C2:C1000 can have one of four Areas (North, South, East, West)
Within each sheet i can filter by "Area" and see how that area did within that timeframe
Each sheet is built the exact same way, but the hours and dollars are different.
I have a final tab that is named "Combined" which adds up all the totals
What i want to do is be able to filter by area on the "Combined Tab" and it give me the totals throught the spreadsheet, instead of having to filter each sheet (Year1, Year2 and Year3) individually.
Can this be done?
