Let me try to explain my set up.
On Sheet1(Report) I have a table that uses a formula to pull data from Sheet2(Pivot Tables) which is a sheet with 8 pivot tables.
I want to have a date picker on Sheet1 that filters a range of dates. For example One date picker for the earliest date I want to see and a second for the latest date I want to see.
I can go to the pivot table and add the date field as a filter. But this only gives me the choice to select dates. I want to say all dates in this range instead of having to click each date I want to see.
Is this possible? I'm using Excel 2010 and I have the activex datepicker available.
Bookmarks