Help moving data (and more) with a Macro

Hello all,
I am trying to create a button in a spreadsheet that moves data from one cell to another when clicked. In addition to moving the data, I would like to have the date that the data was moved added to another cell in the row. I have successfully accomplished this on the attached spreadsheet. What I would like to do but cant figure out is to copy this button feature to the next row without having to recreate it. I tried highlighting the cells I want to copy the formatting on and dragged it to the cells below... this does copy the formatting and the button to the rows that were included in the dragging. However, the buttons that are created are still moving data from the initial row, not the row that they reside on (hope this makes sense). Ideally, clicking on the button would, as an example, move data from cell A3 to cell C3, insert the date in cell D3 AND create in row 4 the same formatting from row 3 with a button that would move the data from A4 to C4 and insert a date in D4.
Thanks in advance!

Why not move the button away from the row and have it just move the value from the selected cell. i.e. one button rather than a button per row?

BSB

Like this:

Please Login or Register  to view this content.

BSB

That would work for me... but I am unsure how to achieve that. Using the record Macro feature will only make changes based on the cell selected while recording the macro, not on any given selected cell thereafter. Or at least thats how I understand it...

You are too fast!!! lol, I will give that a shot. Thank you!

Fingers crossed it works for you

BSB

BSB,
Many thanks!

Happy to help

BSB