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.....
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.....