I am trying to copy data from one sheet to another sheet one column at a time. The reason is to get the data in a diff order by columns. In this sample I am copying column "A" in sheet Data1 to column "L" in sheet Data.
I am using the following code without any success.
Any help would be much appreciated:
I am trying to grab the data from row 3 to the last row with data in it. Maybe there is a better way to rearrange data in columns, I am not sure of any other way other than to copy them one column at a time.
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
Thanks for any help.