Deleting Duplications

[excellenthelp]

Excellers,

How could I delete rows from sheets("LISTS") with IDs that are not listed in the sheets("Report")?

Attached the sample workbook.

SampleV1.xlsx

Help would be appreciated!

Thanks.

[sktneer]

Please find the attached sheet to see if this is what you want.

[excellenthelp]

Excellent work, sktneer!

I need some explaining for this code:

rng2, Cells(i, 2)

What does 2 represent?

Thanks!

[sktneer]

rng2 is a range as you can see the following line in the code

Set rng2 = ws2.Range("A7:A" & lr2)

So rng2 is a range from A7 to last non empty cell in the column A in report sheet.

And cells(i,2) is is equivalent to cell Bi in the List sheet. When the code runs first time i=1360 so cells(i,2) would be B1360.

[excellenthelp]

Ahh interesting! Thank you very much for a brief lesson.

There still are kind people lingering on the face of Earth these days.

Marking as SOLVED.