Copy row to list on next sheet when checkbox is ticked...

[GARY_DANIEL]

Hi experts,

Hope you're all well, I am looking to copy single rows to the bottom empty row on the next sheet when a checkbox is ticked in said row, deleting the original row on current sheet so that list is always starting from the top.

The sheet will always need to be the current sheet that I am onto next sheet rather that sheet1 to sheet2.

This can be completed either individually and automatically as I tick the box or at the click of a button whereas all of the current checked boxes move over.

Checkboxes are in F2-F21 and I would like the row from A-D to move across. Column E is a "done" action which has a code to drop that row to the bottom of that current sheet.

Hope this gives enough detail.

Thank you for your help!

 

[GARY_DANIEL]

trying to explain this better...

[h=2][/h]

Hi experts,

I am trying to carry a row over to next sheet when a button, specific text or checkbox is marked in column F, it will need to be added to the bottom of the table on the next without overwriting whats already in the table.

Hope somebody can help with this!

Much appreciated!

Gary.​

 

[GARY_DANIEL]

]Is this not at all possible?

Am i Asking too much from Excel?

Can anyone suggest an alternative solution? I am open to ideas.

Thank you!

Gary.