check an entered value in a cell in real time, and if the value already exists

Hi all,

I have a workbook with multiple worksheets that hold customer data. Each list is rather large, so i need a way to control data entry with a view to avoiding data duplication.

Is there a way (perhaps via VB scripting) that I can have Excel check an entered value in a cell in real time, and if the value already exists elsewhere in the workbook, a message is displayed?

Million thanks for any feedback.

de049

Hi,

I am a novice here and although I cannot answer your question with an example, I know that what you are asking can be done.

One thing your going to have to do so these GuRu's here can knock this out is provide them with more detailed information and any attempts you have made to solve the issue.

If you have a list of values somewhere else in the Workbook, like in a range or a range name, etc. that would help.

How are you entering data into the Worksheet? Are you just typing it into a empty cell or is the cell controlled by a macro or a function?

A macro would solve this issue in a For Each loop.

You may also be able to record your own macro using Excel "Find".

Anyway, I've spent enough time replying here for one of these guys to have already figured this all out provided that they had more detailed information.