Hi!
My workbook has two sheets; "Estimate" & "Checklist".
On "Checklist" WS; Column A is a checkbox, Column B is text, Column D is the linked cell to the checkboxes showing the TRUE/FALSE statement.
I want the text in column B to copy and paste into "Estimate" WS when the aligning checkbox is checked, and to also clear from "Estimate" if unchecked. It should paste from B15 downwards into the next blank cell. The order doesn't matter, either in the original listed order or the order it is selected/checked (which ever is easier). I can get my code working on if I am having it copied to a blank sheet, but if trying to get it into "Estimate" is just clearing all the text in the sheet without copying anything.
Heres the code I have in a module;
and then I have this code against each checkbox;
I've attached the basic workbook without any macros set up in it.
Bookmarks