I have 7 pairs to make mannager and co. Worker .-
the mannager will be in A6:G6
Co worker will be in A7:G7
I want to make in those cells dsta validation so when I choose in the mannager cells name I will get in the data validation of the co. Worker cell underneath only the names of the people he can work with - A2:A4 for David B2:B4 for tina and so on.
But if I used some name not matter if as mannager or worker in the next cells I will not see his name in the drop down list