Mike,

Along the lines of

Worksheets("Sheet2").Range("A66536").End(xlUP)(2). Value = _
Worksheets("Sheet1").Range("A1").Value

HTH,
Bernie
MS Excel MVP


"Mike" wrote in message
news:M23he.78060$WI3.54417@attbi_s71...
I have made a macro to copy and paste data from sheet1 to sheet2. I want
to be able to retain that data on sheet2. Sheet1 will be updated daily
and
the marco ran again. Is there a way to have a macro go to the next
available row on sheet2 and paste the new information without disturbing
the
previous data?

Thanks
Mike