Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank

**vinaynaran** · 01-28-2016, 08:26 AM

Hi all,

I am beginner of Excel Macro.
I want something like Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank.

I want...
In Today Sheet I want Select Report Filter "Today" and refresh Pivot Automatically
In Tomorrow Sheet I want select Report Filter "Tomorrow" and refresh Pivot if "Tomorrow" is not exists then select Blank

Please see attached file for more explanation

Thanks
Vinay

**humdingaling** · 01-28-2016, 07:13 PM

are you planning to physically have a column for Today and Tomorrow? or are you doing this as part of the visualisation of your problem?

ie have a formula like

Formula:

Please Login or Register  to view this content.

in column D

**vinaynaran** · 01-29-2016, 06:13 AM

Hi,
I want macro a select Report Filter Atutomatically.

Let's assume in Data sheet Column D (Booking Day) we have "Tomorrow" in Some rows, then In Pivot table of Tomorrow Sheet report filter has to select "Tommorrow".

If Data sheet Column D (Booking Day) we do NOT have"Tomorrow" , then In Pivot table of Tomorrow Sheet report filter has to select "Blank".

Hope it's clear now!

Thanks
Vinay

**humdingaling** · 01-31-2016, 10:40 PM

what version excel are you using

i have a solution in mind that will not require you to have a column "D" for booking day (or not use it anyway) but it is dependant on your excel version

**vinaynaran** · 02-01-2016, 08:59 AM

Hi,
I am Using Excel 2010.

Hppay to see your solution if it's work!

Thanks & Regards
Vinay

**humdingaling** · 02-01-2016, 07:44 PM

ok
this solution works for excel 2007+

i changed the datasource to be a named range which is the table i setup for your data

below is the code i have used

Please Login or Register  to view this content.

the coding is commented so you can follow what is going on

i couldn't think of a better way to check the pivot field filtering
im sure there is a better way but this serves its purpose and the principal is adaptable to different solutions

**vinaynaran** · 02-02-2016, 08:47 AM

WOW! Excellent solution. It work like charm.

Thanks a lot
Vinay

Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank

LinkBack

Thread Tools

Rate This Thread

Display

Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank

Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

Re: Select Automatic Report Filter in Pivot where Filter exist in Data table else select B

Thread Information

Users Browsing this Thread

Similar Threads

Filter in Pivot Table's Report Filter

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

Select Multiple Dates In Report Filter Pivot Table But Dates Are Not Static

Select (ALL) in a pivot table filter

[SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?

Place a number filter on a report filter in a pivot table

Select and unselect items in a filter in pivot table

Bookmarks

Bookmarks

Posting Permissions