Moving data from one place to another
Sub Macro1()
For i = 1 To 100 Step 2
Range("L" & i & ":O" & i).Select
Selection.Cut
Range("C" & i + 1).Select
ActiveSheet.Paste
Next
End Sub
Adjust the 100 (table size) to suit your needs.
--
Gary''s Student - gsnu200829
"Karen Sigel" wrote:
I have a spreadsheet with several thousand rows. I made every other row blank
using a macro I found here (thanks!). Now, I need to move the data that
resides in Row 1 L, M, N, O (a populated row) to Row 2 C, D, E, F (the blank
row I inserted) for the whole sheet.
Is this possible? Can someone help me out?
Thanks-
Karen
|