russelgreen
New Member
- Joined
- Nov 21, 2012
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Afternoon All,
I've had some assistance with a sheet which finds key words and counts them. I'm going to have 52 tabs for each week of year. The issue I have is that I want to have a running year-to-date page at the very front. When I filter the information on one of the week tabs it then messes up the ytd totals.
How do I pull totals back to the year overview page even if the location of the information changes on the week tabs.
I've had some assistance with a sheet which finds key words and counts them. I'm going to have 52 tabs for each week of year. The issue I have is that I want to have a running year-to-date page at the very front. When I filter the information on one of the week tabs it then messes up the ytd totals.
How do I pull totals back to the year overview page even if the location of the information changes on the week tabs.
| Macro Master Feedback 2020.xlsm | |||
|---|---|---|---|
| D | |||
| 12 | Building | ||
Year Overview | |||
