JasonTrauger
New Member
- Joined
- Mar 3, 2016
- Messages
- 6
I recently built a dashboard at work that would compare a specific week for 2015 and 2016, in regards to revenue, spots aired, and other financial metrics. The boss of the person for whom I built that dashboard wants to see this in a cumulative sum (i.e., if I choose week 9, it would be the aggregate of weeks 1-9) instead of the current week vs. week setup. The data reads off of a pivot in another tab whose row labels are Region and Week of Broadcast Year. SO, I need a macro that would read a specific cell, which the user types in the desired week number, that would change the pivot table in question to change the Week of Broadcast Year from "all" to, in this example, choosing weeks 1-9.
I appreciate any and all suggested help on this. If the various readers don't have the solution, I'll take suggestions to good books on how to learn about creating macros. This has gone from something that wasn't necessary to a work specific need in a hurry.
I appreciate any and all suggested help on this. If the various readers don't have the solution, I'll take suggestions to good books on how to learn about creating macros. This has gone from something that wasn't necessary to a work specific need in a hurry.