Button copy to next page

[NEXTinLINE]

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

[Leith Ross]

Hello NEXTinLINE,

Welcome to the Forum!

Can you provide an example of these formulas and what needs to be changed?.

...it needs to plug the numbers into certain pre-set forumlas on the next days table.

As a new member of the Forum please read the rules. You can click on the link below...

Forum Rules

Sincerely,
Leith Ross

[NEXTinLINE]

Thanks for the reply Leith.

I have eliminate the need for the selected data to go into formulas on the second page.

What I need is to be able to assign a macro to a button that will copy the Range B3:H3 on the first page, and paste it onte a table on the second page. The data labels (column headers) on both pages are the same. The problem having is, It will not always paste into the same range on the 2nd page. I'd like it to start with trying to paste into B3:H3, but if there is data in those cells, I'd like it to automatically past into B4:H4, if those have data, It needs to then try B5:H5, etc...