Hello! I've added a drop down list as a column on a pivot table and I want users to make a selection from the drop down list for each row of data listed in the pivot table. The problem is when a filter on the pivot table is selected, the drop down list selection remains in the cell rather than with the row of data it was intended to be associated with.
Is there a way to save to the data source (another tab in the workbook) the drop down list data selected in the pivot table?
Thank you!
Bookmarks