Mysore
03-15-2016, 06:52 PM
Hi Folks
Attached is a sample file. Looking for a VBA solution to filter the Pivot Filter field from a list and then create a pdf file.
In the attached file , I have a ProductList holding values A , B & C. I need pivot table to refresh for each corresponding values from the list and then generate a pdf file. If there is no data for a specific product Say C in my sample data, I want the sub routine to omit completely without creating any blank pdf.
Appreciate any help.
Thanks
Mysore
Attached is a sample file. Looking for a VBA solution to filter the Pivot Filter field from a list and then create a pdf file.
In the attached file , I have a ProductList holding values A , B & C. I need pivot table to refresh for each corresponding values from the list and then generate a pdf file. If there is no data for a specific product Say C in my sample data, I want the sub routine to omit completely without creating any blank pdf.
Appreciate any help.
Thanks
Mysore