VBA to Select Multiple Weeks in Pivot Table based on User Input

**burrow.philip** · 03-26-2014, 01:28 PM

Hello,
Have been going round and round on this!

I have a set of data that shows sales dollars by weeks. Currently, that data is in a Pivot table. I'd like to have a macro that selects the weeks (1-52) based on my input. For example. If I want to see weeks 5-52, I want to be able to input "5-52" somewhere and have a macro run that will select weeks 5-52 in the pivot table instead of having to go in and manually select each.

Is this possible?

Thank you,
Phil

**AndyLitch** · 03-27-2014, 11:36 AM

In the filter options above the checkboxes you can use the "Value Filters --> Between" option.

VBA to Select Multiple Weeks in Pivot Table based on User Input

LinkBack

Thread Tools

Rate This Thread

Display

VBA to Select Multiple Weeks in Pivot Table based on User Input

Re: VBA to Select Multiple Weeks in Pivot Table based on User Input

Thread Information

Users Browsing this Thread

Similar Threads

Using VBA to select multiple values in a pivot table report filter based on a cell value

Macro to select rolling/latest 6 weeks in a pivot table

Help filtering a pivot table using input from the user

Select Data Based on User Input

Updating value in table based on user input

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions