I have names in column A which have been sorted. There is also data in cols b, c, d, etc.
I now see that I have duplicates in column A. I would like to have VBA:
1. Select BOTH duplicate entries (i.e. the complete rows) in SHEET 1
2. Cut the two rows
3. Paste them to SHEET 2 (cell A1).
4. Go back to sheet 1 and delete the now empty two rows,
5. Find for the next two duplicate entries in column A,
6. Cut those two rows
7. Paste them to sheet2 directly underneath the rows I pasted a moment ago.