brothertruffle880
asked on
Excel 2010 VBA - MOVE duplicate rows in SHEET 1 to SHEET2
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.
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.
Can you only have duplicates, or can there be triplicates or more?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did that work for you?
ASKER
Absolutely perfect. Thanks!!!
You're welcome and I'm glad I was able to help.
Marty - MVP 2009 to 2013
Marty - MVP 2009 to 2013