I have a pivot table that contains dates. The tree has to be drilled down to get to individual days. ex. Fiscal dates is the name, then comes fiscal year, then fiscal period, then WEEK then day.
I want to create a drop down box that has week ending dates in it which I click on a specific week ending date and with a macro it drills down within the pivot table and selects this particular week ending date. Does anyone have an idea on how to write this macro??
Dan
I want to create a drop down box that has week ending dates in it which I click on a specific week ending date and with a macro it drills down within the pivot table and selects this particular week ending date. Does anyone have an idea on how to write this macro??
Dan