I am having problems programming a button in excel. I have a spreadsheet I fill out daily, with some data rows needing to be carried over to the next day. I would like to add 1 button to each row that automatically carries that row to the next days table (which is in the same workbook as a seperate sheet).

The problem I'm having is that it needs to copy the row you like to the top row on the next page, and if that row has data in it, it needs to copy it to the 2nd row, if the top 2 are full it needs to copy it to the 3rd and so on.

The "insert row" function will not work as it needs to plug the numbers into certain pre-set forumals on the next days table.

Any help would be greatly appreciated.
Thanks