Adjust Pivot Table Filter based on a Range

S

sgltaylor

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Doughnut Chart linked with the slicer in the pivot table 0
Dealing with the error: unable to filter on excel hc home school 0
Dealing with a Pivot Table (when I don't want to) 0
VB Macro for Pivot Filter Function 0
Creating a Chart on form from selected data in query. 0
Selecting Date Range in a Pivot using VBA 0
Creating a Search using a combo box and then creating a report. 4

Top