Show Detail of Pivot Table

  • Thread starter Thread starter Michael Smith
  • Start date Start date
M

Michael Smith

Does anyone know the code on how to "show detail" of a variable in a
pivot table? I have a sub that pivots all employees and I want to see
the detail of one employee in paticular.
Thanks in advance.
 
Strangely enough:

Range("C16").Select
Selection.ShowDetail = True
 
The cell will not always be the same. But the Employee will always be
there....therefore opening cell C16 won't necessarily be the employee I
need.
 
It was an example Michael

Obviously you would need to write code to identify the appropriate cell.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Excel 2010 Pivot Table 2
Pivot table multiple filters 2
Pivot Tables - Multiple Ranges 9
Pivot Table Question 2
Pivot Table - Show All 0
Pivot Table Refreshing 2

Back
Top