I have data in Sheet 1, column AB that I want to move to Sheet 2, column B. I've used the following vba but cant seem to get it right
VBA Code:
Sub Test4()
Sheets("Sheet1").Activate
End Sub
Sheets("Sheet1").Range("AB2:AB").Copy
With Sheets("Sheet2").Range("B" & Rows.Count).End(xlUp).Offset(1)
.PasteSpecial Paste:=xlPasteColumnWidths
.PasteSpecial Paste:=xlPasteValues
End With
End Sub