Need help with VB code for saving cell data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top