Forum Discussion
Linking Checkboxes to cells on multiple sheet
I am working on a Project to use to track the collection a various data. In the project I have different sheets that organize the data into groups of similar data and I have a checkbox next to track ...
Bold question: Why are you keeping more than one list of the same information? Keeping just one list of data solves this issue entirely and makes managing of and reporting on your data ever so much easier.
Because the data I am tracking is a list of items collected for a game so I have separate sheets to track the items by item type but I also wanted to create a sheet that worked as a master list of all the items. Currently the seperate item lists have a check box linked to the cell it is in so I can track the information and highlight the row once the item is marked as collected. I am trying to find a way so that regardless of whether you mark the item collected in the master list or in the categorized lists it will be marked off on both list and apply the highlight. Honestly I'm not even sure this is currently possible in excel but I figured I'd ask to see if by chance it was.
- You can, but it is far easier to add a column to your master list that says which "sheet" that data originally was on. Format the range as a table and you can add a slicer to easily filter for what used to be separate tabs in your file. Much easier to maintain.