Drop-Down List In Expanded Data from Pivot Table

[awkwardbeta]

Hello everyone!

I'm creating a report using a pivot table that when users double click their name and dollar value, a separate sheet will be created with data only pertaining to their name. This part is done.

However, I also want one of the columns, dubbed "Action List", to have a pull-down list for each cell so the users can pick the appropriate action item for each list. I created the pull-down list in the original data spreadsheet, but the pivot table doesn't carry over the pull-down list when a user expands the data (ie. when a user double clicks their name and a new sheet is created).

Can anyone help with this? Thanks!

 

[Jerry Sullivan]

Hi and Welcome to MrExcel,

VBA could be used to add Data Validation (DV) drop downs to the cells in the "Action List" field of your PivotTable drill down table automatically after the table is created.

If you'd prefer users to make their Action List updates directly in the original PivotTable source data, then the code in this thread could work for you...
http://www.mrexcel.com/forum/excel-questions/778468-modify-pivottable-double-click-behavior.html

Just ask if you want help implementing either of those approaches.