Hi,
I have a report where there are multiple headers and the clients want to see the data in rows as well as page. I could figure the code to use for page "ActiveSheet.PivotTables("PivotTable1").PivotFields("Site").CurrentPage = Range("U2").Value". Can anyone please help me with the code to be...