I posted this in Mr. Excel Website but no response yet. here is my question.
Hi & Attention all MVPs I got a situation here.
I am trying to create a Hierarchy in check boxes. My example file is here
http://ift.tt/21uWL0r
I have check boxes for different levels e.g. Lowest level is "Sub Division" then "Division" then "Oil Sector Business" or "Gas Sector Business" then Company as a whole. Please have a look at the attached sheet. i want to link these check boxes so that if i select a division, then all sub divisions within that division are selected. Likewise if i select Oil Sector then all divisions and sub divisions in Oil Sector selected.
By selected i mean True.
Any help or ideas will be appreciated.
Aucun commentaire:
Enregistrer un commentaire