Mccann
New Member
- Joined
- Aug 10, 2014
- Messages
- 20
Hey Guys!
I own a valet parking company
I have a list for the guys that says which day of the week they are available to work.
I have a list for the guys that says which accounts they have been trained at.
I would like to have a data validation drop down list that cross references the 2 lists and shows who is trained, and who is available.
With that said, I would also like to be able to reference a cell in the same row that has a date in it.
So essentially I need to figure out how to combine the (2) lists with one of the date variable dependent on a cell value
Thanks in Advance!
I own a valet parking company
I have a list for the guys that says which day of the week they are available to work.
I have a list for the guys that says which accounts they have been trained at.
I would like to have a data validation drop down list that cross references the 2 lists and shows who is trained, and who is available.
With that said, I would also like to be able to reference a cell in the same row that has a date in it.
So essentially I need to figure out how to combine the (2) lists with one of the date variable dependent on a cell value
Thanks in Advance!