Macro buttons and saving new lines to other worksheets

[Mikejg49]

I would like to allow a worksheet to be updated and then have a save button to save the new lines at the same time I would also like to copy certain values (columns) from the new lines to another spreadsheet in the same workbook. I would also like an archive button to move all lines with a value in the archive column to move to the archive spreadsheet (adding to the prior list).

I've tried to this using basic help but have been totally lost.

Thanks

Mike