Populating a table using multiple Drop Down List Boxes

[ExcelEddie]

Hi,

I have 2 drop down list boxes (DDLB):

DDLB 1 - Shows individuals' names

DDLB 2 - I want to show a list of unique numbers relating to that individual


I have a source data table including all relevant information - Fine
I also have a Pivottable showing all relevant information however the unique numbers are showing in the pivottable within the row as this is the only location they will show as the number and not as a sum of or average of or count of etc...

Basically I have multiple occurances of same name but each occurance will have a different unique number.

Q: How do I get the uniqiue number from either the pivottable or the source data table?


Hope I have explained myself clearly.

Thank you anybody,
Eddie