Hello

I have a spreadsheet with A column of a list of names and another column of projects associated with those names in a random order. The code I have makes me able to select a unique name in a dropdown box and then select a project according to that name in another dropdown box. I want to have an entire column of dropdown boxes where this can be done however the code only makes it work in the first row, [B9 and D9]. I would like the dropdown lists to go all the way down to [B1000 and D1000] if possible.

here is the code


Please Login or Register  to view this content.
The list of names is in column X and list of Projects is in column Y.
Can I amend this code to make that possible?