validation and other question

[viper]

I'm looking for some way to tell if an invoice has already been input. I have a spreadsheet with 8 pages where we input our invoices. I need to prevent a duplicate entry with a msgbox warning. I have tried using data validation on a previous spreadsheet but that didn't produce the results I wanted. We input the invoice number in C9:C38, on all eight pages. If a duplicate entry is made I need to notify the user of the fact.

Sorry the other question I will work on first before I ask for help.

Thanks,

 

[Dan Aragon]

Click here for answer...

 

[Aladin Akyurek]

On 2002-02-25 17:23, Dan Aragon wrote:
Click here for answer...

Dan,

I'd like to see the ISNA+VLOOKUP formula up there changed to:

=COUNTIF($A$1:A8,A9)=0

Aladin

 

[viper]

Thank you both. I will try both.