Generic replies will be ignored. You must specifically address the problem and prove that you can solve it.
Need someone to quickly code to select a range of values in a pivot table page field.
That range would be a From and To date for example.
There is one date in my pivot table. I want to select from Jan 1st 2006 to
July 12th 2006 for example.
I want the user to enter it as a range and not have to click any set of multiple dates.
Should be able to change selection criteria for a page field or one of the item fields.
Must provide working code in the attached spreadsheet.
I followed the example in Mr Excels book on selecting page fields on a pivot table outside the pivot table using a macro but the From and To requirement I have is not to be found.
[img][url removed, login to view][/img]
Here is the sample excel spreadsheet where I have a pivot table defined
[url removed, login to view]
Hi I can do this project. I have 6 years of VBA experience across various versions. I think it is straight forward. Awaiting your reply to start. Thanks Aman