yunjiedeng
03-20-2017, 08:28 AM
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
abc
edf
123456
123456
So it will become:
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!
a b c
abc
edf
123456
123456
So it will become:
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!