Referencing a pivot table drop-down entry

[glenlee]

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]

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