Auto Populate Drop Down Box created in Format Control

[mjg060468]

Hi

I hope I am in the right place. I have a spreadsheet which users select answers via drop down boxs which are set up via format control and use a cell link. What I would like to know is if it is possible to auto populate another format control drop down box based on answers from two of the other drop down boxs. I know that this makes no sense at all, but if someone could help it would be great

[MickG]

Assuming DropDown 3 , is to be to filled from selection in DropDown 1 & 2 . then try this.
Place codes below, in DropDowns 1 & 2.
When you change either Dropdown 1 or 2, Dropdown 3 will be Altered accordingly.

Please Login or Register  to view this content.

Mick