I have been working on the following for three days solid and still cant figure it out!
On Worksheet 1 (RISK CHECKLIST) I have a list with checkboxes assigned to each row in Column B. If the checkbox in Column B is ticked I want it to copy the corresponding number in Column A of worksheet 1, and paste it in column A Worksheet 2 (called RISK ASSESSMENT)
I still need to enter the checkboxes in Worksheet 1 B12 onwards but Ill try and explain a different way
Worksheet 1 - B9 AND B11 boxes ticked, copies data in A9 and A11
Worksheet 2 - Pastes the above into A8 and A9
If anyone can help me with this I will be forever grateful (and will sleep better :-))
Thanks a million