Linking Checkboxes to multiple cells on multiple sheets.

Question

I am making a sheet to track item collection in a game. I have different sheets for the different types of items and on each sheet is a list of the items with a checkbox next to it to so I can track what items have been collected. I also have a master list that has all the items on one sheet. What I am trying to do is link the checkboxes on the master list and the sub lists so that I can check either one and they both will get marked off. Is there a way to link the checkboxes/cells together so they do this automatically rather than me having to check it in the master list then go to the sub list sheet and check it there as well.

Answer 1

You may assign same cell link for both checkboxes. Then it will check both when any one is checked.