Please see the following example: Column A, B, and C. What I want to use VBA to do is: in the exel spreadsheet, if there are duplicates in Column C as in the example, I want to copy and paste A and B column values to the next row.
a b c
So it will become:
abc edf 123456 123456
a b c
abc edf 123456 abc edf 123456
There are about 50 rows, and this kind of situation appears unregularly and randomly, but only these three column. PLEASE HELP! THANK YOU SO MUCH!