M
msmylie
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
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