See http://www.contextures.com/xlDataVal03.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"nick_thomson"
wrote in message
news:nick_thomson.25fk6n_1143634203.0645@excelforu m-nospam.com...

Hi

I have a spreadsheet that has multiple worksheets each containing lists
of items at a warehouse. Each item needs to have a unique number.

When adding items to this spreadsheet I would like, if possible, to
have a function that allows me to choose a unique number from a drop
down data validation list, such that if I were to choose a particular
number from this list in one cell, then that number would be removed
from the list for any subsequent cells. Also, if an item is removed
from any of the worksheets, that item's number should again be
available in the list.

Is this possible with a function?

Many thanks in advance.

Nick Thomson


--
nick_thomson
------------------------------------------------------------------------
nick_thomson's Profile:
http://www.excelforum.com/member.php...o&userid=32929
View this thread: http://www.excelforum.com/showthread...hreadid=527536