Go to "Grand Total"

[ms.fb]

I really hope this makes sense.

I am trying doing a VBA where I copy data from one pivot table, and then past the data in another.
In order to copy my data I need to "get detail" from the Grand Total in the pivot table. That cell alw ays changes depending on how much product is in the list. How do I make the coding understand it's always the "grand Total" it has to select. It will always be in Column I, but the row # changes.

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

[southward]

Hi,

This website shows how to read data from a pivot table.

http://www.databison.com/how-to-read...ble-using-vba/

Hope this helps.

[ms.fb]

Ahhh this feels super confusing. I feel like I definitely don't know enough for this.

[southward]

Try something like this.

Please Login or Register  to view this content.

[humdingaling]

assuming Grand Total is in column A

Please Login or Register  to view this content.