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
Bookmarks