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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of copy/pasting data and retrieving results 0
HELP "HOW NOT TO USE THE SAME DATA TWICE" 3
New topic from discussion "Align cells with same value - vba almostworking" in this group 0
Transfer data between two worksheets 10
How do I "PUSH" a cell value from one Worksheet to Another? 4
Excel VBA - Find value in external workbook, same folder 0
Need help cleaning up a macro that "copies" data from another work 1
Retrieving a field from another worksheet - with conditions... 3

Top