Hi,
Can someone tell me how to name a range from a column in a pivot table that automatically changes when the pivot table does?
For context, my pivot table is distilling data for me into only unique values. I want to insert drop down lists that draws from the named range.
I.e 'Data Table' (all data) -> 'Pivot Table' (distilled data with dynamic named range) -> 'Drop Down List' (unique data only from named range). Steps 2 and 3 here need to happen automatically as data is added (or maybe deleted) from the Data Table.
Any help would be greatly appreciated.
Bookmarks