ExcelBanter - Need help with VB code for saving cell data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need help with VB code for saving cell data (https://www.excelbanter.com/excel-programming/285561-need-help-vbulletin-code-saving-cell-data.html)

Nupiter

Need help with VB code for saving cell data

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.

Tom Ogilvy

Need help with VB code for saving cell data

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

--
Regards,
Tom Ogilvy

"Nupiter" wrote in message
...
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.

All times are GMT +1. The time now is 12:22 AM.