VBA to look for duplicate item in another worksheet upon data entry

[DUMMY1]

Hello,

1. I have two worksheets in a workbook both containing same item (PART#).
2. Sheet 1 - Master List
3. Sheet 2 - Data Input
4. After data input (PART#) in Sheet 2, VBA will search for identical PART# in Sheet 1.
5. VBA will prompt an input message "Duplicate PART# found! Do you want to delete (Y/N)?"
6. If yes, VBA will delete entire row having the identical PART# in Sheet 1.
7. In the same token, the row containing the new PART# in Sheet 2 will also be removed.

I have been working on this for two weeks (with or without VBA) but nothing has worked. Could someone please help?

Thanks!.

DUMMY 1

 

[JoeMo]

Hi Joe,

The run-time error was caused by some protected columns in SHEET 2. I added on ActiveSheet.Unprotect Password:= and the codes are working fine now.

Thanks a lot!

You are welcome - thanks for the reply.

Always a good idea to let us know details like "sheet is protected" in your initial post.