Need help with VB code for saving cell data

N

Nupiter

Please help????!!
I am trying to save data from one cell in worksheet1 to worksheet 2 in same workbook via a button. I also need it to move to the next empty row. Struggling with this for days.
 
T

Tom Ogilvy

copy ActiveCell.Value _
Destination:=activecell.parent.next.Cells(rows.count,1).End(xlup)(2)

--
Regards,
Tom Ogilvy

Nupiter said:
Please help????!!!
I am trying to save data from one cell in worksheet1 to worksheet 2 in
Click to expand...
same workbook via a button. I also need it to move to the next empty row.
Struggling with this for days.
 
Top