im looking to have a drop down list on sheet2 that displays unique items in column A on sheet 1.
then when an item is selected from the drop down list, i want to be able to display all unique values that correspond to that option.
i have attached an example worksheet
note that the data on sheet1 is ever changing
any help?
Bookmarks