Birinder
New Member
Hi,
I have a Pivot table which shows Volume and % of each customers. I Have a macro that goes by each customers one by one, and prints out the information on a pdf file for each individual pivot values for each customer.
My issue is that my customers also want to include data that is only related to them. I can get the data by right clicking on Show detail, but not sure how to add it in my macro, so that it also gets prints out in a separate file.
I am uploading the file, there is no sensitive data. I am looking for detail get printed out automatically as shown on tab Sheet1.
Thanks everyone,
Birinder
I have a Pivot table which shows Volume and % of each customers. I Have a macro that goes by each customers one by one, and prints out the information on a pdf file for each individual pivot values for each customer.
My issue is that my customers also want to include data that is only related to them. I can get the data by right clicking on Show detail, but not sure how to add it in my macro, so that it also gets prints out in a separate file.
I am uploading the file, there is no sensitive data. I am looking for detail get printed out automatically as shown on tab Sheet1.
Thanks everyone,
Birinder