Lots of ways, here's one.

Sub copytonextsheet()
Set destsht = Sheets("sheet12")
With destsht
lr = .Cells(Rows.Count, "a").End(xlUp).Row + 1
ActiveCell.Copy .Cells(lr, "a")
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

uk"
wrote in message ...
is it possible to write something to automatically save info to the next
empty cell on another sheet