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?