• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Show Detail in Pivot Table

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
 

Attachments

  • 3F9C5000.xlsm
    163.7 KB · Views: 8
Code:
  Range("G7").Select
  Selection.ShowDetail = True



Thanks, I am not good with VB Macro coding ,, would you please show me where in my code I include this :

Range("G7").Select
Selection.ShowDetail = True


Thanks again,

Birinder
 
I want to save the detail for each customer on a PDFs format, and saved with customer's name and today's date.
 
Back
Top