So I am not sure if this is possible. I want to use Data Validation to work the following:
Let's say I have a sheet with a list of lockers. This is the LOCKERS sheet. All the locker numbers are listed in column A. In column B there is Assigned/Status. This column has one of the following for each locker number: A name that the locker is assigned to...or the word BROKEN which means they are unavailable....or the word OPEN which means they are available. Column C is the shift number which is not really important for this. On the sheet I want to use Data Validation, which we will call employee tracking, I would like a drop down list displaying only the locker numbers that are available. On this sheet is also a list of employees. So as I assign the lockers on the EMPLOYEE TRACKING sheet the LOCKERS sheet will have to update somehow so that the proper lockers are shown in the data validation drop down menu.
Sound like something that can work?
Let's say I have a sheet with a list of lockers. This is the LOCKERS sheet. All the locker numbers are listed in column A. In column B there is Assigned/Status. This column has one of the following for each locker number: A name that the locker is assigned to...or the word BROKEN which means they are unavailable....or the word OPEN which means they are available. Column C is the shift number which is not really important for this. On the sheet I want to use Data Validation, which we will call employee tracking, I would like a drop down list displaying only the locker numbers that are available. On this sheet is also a list of employees. So as I assign the lockers on the EMPLOYEE TRACKING sheet the LOCKERS sheet will have to update somehow so that the proper lockers are shown in the data validation drop down menu.
Sound like something that can work?