drop down and more

G

Glenn

I hope that someone can help me out with this.

I have a worksheet that contains a list of computers and their details -
serial numbers, etc.

I have another workshop that contains a list of where I need to put them.

I'd like to set it up, so that working on the list of computers, I have a
column where I can pick from one of the locations that I need to put one,
and that after it is used for one location it is no longer available for
another in the drop down menu.

Is this possible? How do I go about setting it up?

Thanks!
 
Top