Using the following code I am trying to copy data from rawdata1 to rawdata2. However I get an outside procedure error with the Offset(1,0) part of code.
Also NOTe; Therer is code to remove duplicates in raswdata 1 . I get the same error if a I remove the duplicate code. Any suggestins??
Sub copy()
Sheets("rawdata1").Range("A1:AC10000").copy _
Sheets("rawdata2").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
Sheets("rawdata2").Select
End Sub
Bookmarks