I was trying to make up a sheet to do some basic calculations but ran into an issue when I found out that you cannot embed checkboxes into cells. Rather, they float on top of the entire sheet. This is no good since I have 45 objects and having 45 checkboxes that are floating isn't at all ideal. If the spreadsheet layout ever changes then I'll have to manually move and fiddle with 45 checkboxes? No thank you.
Now I'm completely at a loss on how to best go about this.
Sample.xlsx
I've attached just a small sample of how the columns will look. Like I said, there will be 45 objects and each object will have between 1 and 6 attributes. These attributes are in columns C through H. Column A is where I was going to place checkboxes. Toggle buttons would be really nice, but they are ActiveX only and I don't know if there are any reasons to avoid ActiveX or not.
I would hide the attributes columns once I had it working and then put an output somewhere off on the right maybe in column J or K. The way it would work is you select any number of objects you'd like (in the real world you would be selecting no more than perhaps 3 or 4) and it would then compare attributes and output the attributes in the output column sorted by number of times they appear. If that doesn't make sense, an example would be if I select objects 8, 9, and 11 and then click the "Go" button the output column would list attributes 7-10 at the top (because there are two instances of it), then 7-11 (also because there are two instances) then it would list all the other attributes after since they each only appear once. Hopefully that is clear enough to understand.
Each attribute can only exist three times, so the output cells can even be colored based on that. If an attribute exists three times in all the selected objects then it can be colored green. If it exists twice, yellow. Only once, red.
Basically, I'm looking for a way to be able to easily select and deselect a number of rows that is easy enough to work with so that I can change the layout quickly and easily.
Bookmarks