I have a a cell that has several check boxes in it, these can be independently checked so that one or several could be checked at one time. I am trying to determine a way to create a formula that will see what is checked and based on those that are checked bring up another set of check boxes.

In other words, I will have a Main Category leading to a Sub Category which could lead to a Sub Sub Category. So that once the user selects the main Categories, they will be led to chose from the Sub Category and if need be, then the Sub Sub Category. Then once they are done, they spreadsheet can be sent to me and I will see all the selections made for each product row and update our website accordingly.

I am not overly proficient with Excel as I mainly work in Crystal, so please be kind and with a simplified explanation.

thanks much!