I am looking to make a spread sheet for work.
Basic concept would be a master list that is a pool of all the tool serial numbers for the particular shop.
After this there would be a separate sheet for each individual job we have running.
I would like to have each job number spread sheet have multiple data validations that reference the master list. I know how to set this part up.
My issue occurs as follows:
Is it possible/ how would you make it so once a tool serial number is chosen in one drop down list for a job, it can not be selected again for any other job drop down lists.
Example:
Master List:
P123
P125
P135
P139
P175
Job #1: (I choose one of the probes from the master list in a data validation list)
P123
Job #2: (when I look at the drop down list, it would look as follows)
P125
P135
P139
P175
(Since P123 was selected in Job #1, it would not show up anymore in drop down lists since the tool cant be used on 2 jobs at same time)
And than for instance I plan on leaving a blank choice with the drop down menu as well. So for Job #1 once I select the blank choice of the drop down menu, it would be basically saying that P123 is now back at the shop and available for use on a different job. So than P123 would be included in all the other drop down lists again.
I hope this makes sense. any help would be appreciated.
Thanks
Bookmarks