PDA

View Full Version : Help! Prompt User for Pivot Table Sort Criteria?



Kacer26
01-12-2011, 12:59 PM
Hello All!

So, I have a question about pivots and filter criteria:

Is it possible to code a macro to prompt a user for say, a date range like:

Date Range is: "Nov-09 to Nov-10"

and then have the pivot table field sort based upon that specified input?

In the attached file I need to prompt the user for the a specified date range ("Monthly Standardized Date") which is the column field and then have the pivot generate based upon that input.

Also, in most cases the seleciton will be a 12mos - 15mos range.....