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.
Bookmarks