Remove duplicated rows from different sheets

[emukiss10]

Hello,

I would like a macro that compares 2 sheets and remove duplicated rows from one of them.

example:

Sheet 1 has 20 rows,
sheet 2 has 30 rows

and in sheet 2 there are duplicates from sheet 1.

I like to delete those rows from sheet 2 that are present in sheet 1. (leaving them only in sheet 1)

Best regards
W.

 

[hiker95]

emukiss10,

To start off, it would help if we could see what both raw data worksheets actually look like?

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[emukiss10]

For security reasons I cannot do that

I would like a macro that compare rows from row 2 on sheet(1) and sheet(2) and if there is a match (duplicate) than delete this row from sheet(2)

 

[hiker95]

For security reasons I cannot do that

I would like a macro that compare rows from row 2 on sheet(1) and sheet(2) and if there is a match (duplicate) than delete this row from sheet(2)

emukiss10,

We know that you have two worksheets, sheet(1), and, sheet(2), but, we do not know what columns your raw data is in for checking in each worksheet.

In order to continue I would like to see sample made up raw data in each worksheet.

See the following link, B. Posting Aids, for ways you can display made up raw data in each worksheet.

https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html[/b]

 

[hiker95]

emukiss10,

If you can not display screenshots, or, your actual raw data, then please answer the following questions.

1. What column in sheet(1)?

2. What column in sheet(2)?

 

[hiker95]

emukiss10,

You have displayed variations of the worksheet names.

What are the actual worksheet names?

 

[hiker95]

emukiss10,

I do have a test macro that does work correctly with some test data that I created, but, I will need the answers to the my questions in my replies #4, #5, and, #6.