B4 is to choose a selection within the top row within the other worksheet, this is then used in column V to pull the unique values (of which I am trying to work out how to put them in alphabetical order, but that's a headache for another time), populating the data validation list in B4
Bookmarks