Hi, I am really new to Excel coding and do not know where to start with this so was praying someone could help me?!
On Worksheet 1 (RISK CHECKLIST) I have a list of Risks, and a checkbox against each risk in Column B. If the checkbox in Column B is ticked, I want to move the corresponding number in Column A to Worksheet 2 (RISK ASSESSMENT) Column A
B8 and B10 checkbox ticked
Copies cell data from A8 and A10
Pastes data into cell A8 and A9
I have attached the spreadsheet to help explain things further (please note I still need to add checkboxes on RISK CHECKLIST from B12 onwards)
Please help me - I have been trying to do this for three days now and am losing the will to live!!