Delete duplicate rows between sheets

Excel has the data in sheet1 & sheet2 from column A to column E.

I need a macro(VBA) that can -

1. Find duplicate rows between sheets and if it finds duplicate rows than it just deletes them in sheet2.

2. Find duplicate rows between sheets and if it finds duplicate rows than it just deletes them in both sheets.

Kind of clumsy code, But it will do the job
(I appreciate if any of forum's Experts provide enhancements to the code...)

Part 1: Delete Duplicates from Sheet2 Only.

Please Login or Register  to view this content.

Part 2: Delete Duplicates from Both Sheets

Please Login or Register  to view this content.

Hi subverter & Kev. Your code is working good. But I forgot to mention that row 1 is header in both sheets. So How to skip that first row.

My code shouldy already be giving you what you need

For a1 = r1 to 2 Step -1 stops when a1 = 2
And
Do until a2 = 2 does the same

If for any reason it is not doing that, then amend the heading in Column A in either sheet and VBA will not find a match when it checks those first cells against each other!

Got it now. Thank you kev.