Hi all, I need your help on VBA for preventing duplicate entry. The requirement as attached file. Hope I can get the support soon. Thanks for your view and support very much.