Hi guys,
how can I create a data validation list from pivot table which data are changing?
1) first problem I have with Pivot table displaying "(blank)" row
2) second problem I have that the data val. list is displaying all blank rows from the range I specified and also the not wanted "(blank)" value
See attached xls.
excel_DataValidationList_PivotTable.xlsx
Thanks for any tips.
Bookmarks