Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adjust Pivot Table Filter based on a Range
Hi All,
I would really appreciate help with the following. I have an Excel 2007 workbook with two worksheets. On sheet 1, I have a pivot table with a filter on a date field. On sheet 2, in cells B2 to B4 I have three dates. I need some VBA code which will change the filter on the pivot table on sheet 1 to the same dates as entered in sheet 2. A note on the dates, there may be only 1 date entered up to a max of 3 different dates. Any suggestions would be most welcome. Cheers, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal based on a range of data in Pivot Table | Excel Worksheet Functions | |||
Exclude data from Pivot Table based on filter? | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
pivot table and critera range filter | Excel Discussion (Misc queries) | |||
Filter based on Pivot table | Excel Worksheet Functions |