Comparing 2 cells and copying rows to new worksheet

I have a list of several company names and addresses that has multiple duplicates. I want to create a macro that will remove the most obvious duplicate entries by comparing company names.

What I'm looking to do is compare B2 to B3 - Company names are in column B and have been sorted. If B2 = B3 then copy row 2 & 3 to Worksheet 2. Once row 2 & 3 have been copied, compare B3 & B4.

Any suggestions on how to get started with this?

Hi,

As far as duplicates are concerned, Chip has done an extensive analysis of all possible cases ...

http://www.cpearson.com/excel/duplicat.htm


HTH
Carim