I need a combo box with 5 options in it.
If I choose Option 1 from the box, then in the cell to the right of it I need 5 further sub options to appear as options in a combo box, so they are related.
And if I choose Option 2 in the box then to the right in the next combo some sub categories which relate to option 2 appear.
How can I do this.
If I choose Option 1 from the box, then in the cell to the right of it I need 5 further sub options to appear as options in a combo box, so they are related.
And if I choose Option 2 in the box then to the right in the next combo some sub categories which relate to option 2 appear.
How can I do this.