Delete duplicate rows

[RAJESH1960]

Hello guys,
I failed to notice that there were duplicate rows in the 2B sheet which I have to delete first and then run the code shared by Bebo02. Instead of manually deleting it, I would appreciate it if someone can edit the code in the beginning to search for duplicate rows in the 2B sheet and remove them first and then run the rest of the code to create Portal sheet. I have added some duplicate rows in the 2B sheet manually in the same workbook shared earlier.

Remove Duplicate rows.xlsm

 

[RAJESH1960]

Sorry. My bad. I made a big blunder. There can't be duplicate values in 2B. I wanted to check the code with a new data and by mistake I inserted the wrong sheet which had duplicate rows. The code is perfect and needs no editing.
So, Please avoid this post. Sorry once again.