Hi, I have large data of name and number and currently doing the work manually. It will be very helpful if you can help me to automate this with Macros.
I have excel sheet like this,
Now I want a Macro to compare maximum three cells in column B and if cells match then those rows should be moved to next sheet.
If possible fourth identical row should be deleted.
For example,

A B
123 | John
124 | John
125 | John
126 | John
127 | Michael
127 | Michael
128 | George
129 | Willy
129 | Willy
130 | Willy

I want first three John rows moved, the last John row to be deleted, Michael rows moved, Willy rows moved (to next sheet) and George row remains.

Thanks in advance
Regards,
Nicks