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.