I have two worksheets... "TRANSACTIONS" and "MANUAL ADJUSTMENTS"
The two sheets have similar types of data but the columns are in different orders.
Here is what I've got so far:
Code
Sub MoveColumnsFromMANUALtoTRANSACTIONS()
'
' MoveColumnsFromMANUALtoTRANSACTIONS Macro
' get data on sheet "Manual Adjustments" and past to proper columns on "Transactions"
'
'
Sheets("MANUAL ADJUSTMENTS").Select
Range("A1").Select
Dim myColumn As Range
Set myColumn = Range(Range("A2"), Range("a2").End(xlDown).Offset(0, 0))
myColumn.Copy
Sheets("TRANSACTIONS").Select
Range("A1").Select
Selection.End(xlDown).Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' that seemed to work
' but now I see why some go to the bottom and xlUp
' now for column B
Sheets("MANUAL ADJUSTMENTS").Activate
Set myColumn = Range(Range("b2"), Range("b2").End(xlDown).Offset(0, 0))
myColumn.Copy
Sheets("TRANSACTIONS").Select
Range("b2").Select
Selection.End(xlDown).Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
' Ok that worked for column B
' now I need to copy and paste columns: C-C, D-D, E-E, F-F, G-k, (don't use H&I)
' J-G, K-Q, L-R, N-S, O-T
' It would be nice to have a more elegant way than just rewrite same code 10 more times
End SubI am happy to search for solutions (I've learned tons 
just reading other posts) but I don't seem to know what to search for...
any help is very much appreciated!