I am trying to remove duplicate rows in my sheet.

I have noticed that if I am only using one column, I can use advanced filter to remove duplicate entries.

My problem is that I have about 10 columns, and I want to remove the entire row if there is a duplicate whereas column B is my test column for duplicates.


Could someone help me with the vba code or is there a way without coding it.


thank you,

Josh