Copy and paste 13 columns across

[bgonen]

I got values in range (for example B10:B30) and trying to copy each value across 13 columns starting at cell G4, After the copy/paste on the 13 columns I'm trying to skip one column and then again copy the next value (from the range B10:BB30) to the next 13 columns across

Thanks

 

[bgonen]

I tried the following command but I still get an error:Invalid qualifier (in RED)


Sub CopyPasteAcrossColumns()
Dim LR As Long, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = A To LR
Range("A" & i).Copy Destination:=Range("P3" & Columns.Count).End(xlToRight).Column.Resize(13)
Next i
End Sub

In this example I'm trying to copy value in A1 to 13 columns starts at cell P3 (horizontally 13 columns)then
I try to have one blank column and then copy the value in A2 to the column starting after the blank column,,,etc etc

 

[wigi]

Maybe - just a guess because the question is far from clear to me:

Sub CopyPasteAcrossColumns()
Dim LR As Long, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = A To LR
Range("A" & i).Copy Destination:=Range("P" & Columns.Count).End(xlToLeft).Offset(,1).Resize(13)
Next i
End Sub

 

[bgonen]

I'm still getting an error.
I agree, my explanation is confusing
I will create a new thread