Hi,
Please help me with below macro, details are given below
Column A Column B Column C Column D
Date Paid Amt Invoice No. Remarks
12/01/12 $5000.00 7865986 Paid on 12th Jan 2012
14/01/12 $4500.00 7866896 Not Paid
Now what i wanted is if i am entering any dublicate invoice number in...