HELP: "I DONT WANT THE SAME DATA SELECTED TWICE" PLEASE READ

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msmylie@cfl.rr.com - 17 Sep 2007 01:46 GMT

I have a work sheet that uses the VLOOKUP function to enter data form
another worksheet. In WS1 I enter a specific number and it pull the
information from WS2, now while in WS1 I don't want to be able to
select the same number again but would like a message to pop up and
say" that number has been selected already" "please make another
selection". And if possible have the selected number on WS2 either be
crossed through or have the row hi lighted so a quick look could tell
what numbers are still available. thanks for any and all help

Reply to this Message

Gord Dibben - 17 Sep 2007 03:31 GMT

How about use a Data Validation Dropdown list to choose the number from and hide
the previously selected items from the list?

See Debra Dalgleish's site for info and a sample workbook.

http://www.contextures.on.ca/xlDataVal03.html

Gord Dibben MS Excel MVP

>I have a work sheet that uses the VLOOKUP function to enter data form
>another worksheet. In WS1 I enter a specific number and it pull the
[quoted text clipped - 4 lines]
>crossed through or have the row hi lighted so a quick look could tell
>what numbers are still available. thanks for any and all help

Reply to this Message

Rate this thread: