Referencing a pivot table drop-down entry
 

I have a pivot table on sheet 1 of my workbook that shows sales rep
results by sales manager. I select a sales manager from the pivot
table drop down box and the table shows his individual reps and their
results. Simultaneously, sheet 2 shows the count of sales reps from
the pivot table that reached a particular attainment. I want sheet 2
to also show (at the top of the sheet) the sales manager name that is
presently selected in the drop down box of the sheet 1 pivot table.
How do I do this?

If it's a page field, that won't move, you can use a link to the cell,
e.g.: =Pivot!B1

glenlee wrote:
I have a pivot table on sheet 1 of my workbook that shows sales rep
results by sales manager. I select a sales manager from the pivot
table drop down box and the table shows his individual reps and their
results. Simultaneously, sheet 2 shows the count of sales reps from
the pivot table that reached a particular attainment. I want sheet 2
to also show (at the top of the sheet) the sales manager name that is
presently selected in the drop down box of the sheet 1 pivot table.
How do I do this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html