VBA code copy data from one sheet to another error

**jcicero57** · 01-13-2013, 10:00 AM

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

**mike7952** · 01-13-2013, 10:41 AM

Hey Clearwater

Lake Wales here. Im not sure I run your code without errors. Anything else you can tell use about your workbook?

**jcicero57** · 01-13-2013, 02:21 PM

Hi- your almost local.

Not sure what I was doing wrong that caused the error. But it does work. I am trying to use this code to allow for cutting and pasting and clearing in raw data! tab What happens now it appears if I change a cell in rawdat1 it duplciates they entire contents below the first. Is there a way to only update changes? Thanks for your help

Sub copy()
Sheets("rawdata1").Range("A1:AC10000").copy _
Sheets("rawdata2").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
Sheets("rawdata2").Select

End Sub