Hi;
I was trying to create a macro that would copy cells C & D from the 1st row, then move down two rows and copy C into cell A, and D into cell B, then copy the next row of cells C & D, move down two rows again and copy C into cell A, and D into cell B. This would need to loop until it hits blank cells in both cells C & D to copy.
I got a little mixed up with trying to put this together, any suggestions would be appreciated, Thanks!
I was trying to create a macro that would copy cells C & D from the 1st row, then move down two rows and copy C into cell A, and D into cell B, then copy the next row of cells C & D, move down two rows again and copy C into cell A, and D into cell B. This would need to loop until it hits blank cells in both cells C & D to copy.
I got a little mixed up with trying to put this together, any suggestions would be appreciated, Thanks!