Link multiple Active X check-boxes with multiple cells

[GPetcu]

Hello everyone

After some Excel wisdom from someone more experienced than I am.

I have created a spreadsheet (attached) that my team will be using to records lights that have failed in our office building. As the team is not technically inclined I am trying to make it as easy as possible for them to record these.

For each office building there will be a monthly test for lights that needs to be recorded. For ease, I have created multiple checboxes that should be ticked when a light failed. Whilst I have done the first month by manually linking the checkbox to the cell next to it (I am doing this so I can insert conditional formation to highlight the row in red when a light failed) I am after a more "fast" method to do this for the rest of the months. I have attached an example sheet for your visibility.

In small words, I am after a vba that will allow me to link multiple checkboxes (within a defined range) to the cells in the next row. It would make more sense when you will see the document (there is a comment in cell W1).

Thank you for your assistance in advance.

Gabriel P.