Excel Checkbox - How do i duplicate entire row when checkbox is ticked?

[ozc1han]

Hi all,

I've always found my answers to excel questions on mrexcel, however, at the moment I'm struggling! I'm not that experienced with Excel.

I have made a checklist with Check Boxes (Form Control), which is linked to the column beside it. When checked, TRUE appears in the column beside the checkbox and the checkbox highlights the row so it is clearly selected.

When checked I need the row to be duplicated (into another sheet [sheet 2]). When unchecked from sheet 2, I need to row be removed. Sheet 2 is basically going to be where I'd like all checked items from different sheets to appear.
If the row can't be duplicated, I would like it to be moved (into another sheet [sheet 2]).

Any help will be highly appreciated!

Thank you

 

[Logit]

Posting your workbook for review will greatly assist in providing an answer.

 

[ozc1han]

Ok thank you. I will post now!

 

[ozc1han]

I couldn't figure out how to add to this thread. I've uploaded the document onto a drive if that help!

Thank you

checklist (shared) - Google Drive

drive.google.com

 

[Logit]

Was your workbook created on Google Sheets rather than in Excel ?

Nothing I am doing works on your workbook.

 

[ozc1han]

No, it was created in Excel. I dont know how to upload the workbook onto this site, so I shared the link from my google drive.
Hope that helps!

 

[ozc1han]

Here's another link to the excel file. I've uploaded it onto box.com

 

[ozc1han]

Checklist 01.xlsx | Powered by Box

app.box.com

 

[Logit]

.
Here are two versions of just the two sheets in your workbook. You can use the code from either workbook in your project.

Version #1

Version #2

Note: The code includes the use of a CHECK MARK in the cells located in Column D. The "Checkboxes" were removed due to difficulties getting your original
workbook to accept VBA code that functioned as desired.

 

[ozc1han]

Thank you! Works perfectly!!!