Data records are entered into one work sheet and then save to another (the database). Each record is one row.

Normally, I would use the data validation - custom and put the formula below.

=COUNTIF($A$1:$A$50,A1)=1

But you cannot reference another worksheet using this.

So I need some formula which says:

Check if the data in cell B3(worksheet1) is the same as the data in col a3:a20 (worksheet2), if the data in B3(worksheet1) then bring up message "Duplicate Record".

Thanks,

Dave32