HI,

I have two worksheets "PV" & "Register".
PV form is to be completed & will be posted to Register when Use
executes the macro "PostToRegister".

I would like to check if the record being posted is a duplicate entry.

There are two cells named "Beneficiary" & "Amount" in the workshee
"PV" which I want to check against Cols "C" & "G" respectively i
worksheet "Register".

i.e., if both Beneficiary & Amount match any record in the workshee
"Register" it should prompt the user that it is a duplicate entry & as
if the user wants to continue. Otherwise it should post to th
register.

Any help is greatly appreciated! Thanks in advance

--
Message posted from http://www.ExcelForum.com