Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table | Excel Worksheet Functions | |||
formulas referencing pivot table cells | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |