VBA question... i just cannot get my head around!

[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 using onto the next sheet in line 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!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...row-list-next-sheet-when-checkbox-ticked.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.