Another Visual Basic/Dependant Cells issue
 

An issue I have is that in Columns D and E (E is dependant on D).

At the moment in D the options are Analyst Summer, Associate Summer,
Analyst Full Time, Associate Full Time & Summer Quantatitive. Column E has
the respective Locations where each of the option in Column D are listed
(such as London only for Analyst Summer, London, Spain, Italy, France for
Analyst Full Time) and so on. The trouble is if I select Analyst Full Time
with a location of France, and then go back and change Column D to Analyst
summer, which only has London as a location, the location of France remains
in the box when I would like it removed.

Any ideas to get this one done?

cheers

Another Visual Basic/Dependant Cells issue
 

Are these dependent dropdowns, or formulae?

I think more detail on what you have, formulae etc. would help.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Alex" wrote in message
...
An issue I have is that in Columns D and E (E is dependant on D).

At the moment in D the options are Analyst Summer, Associate Summer,
Analyst Full Time, Associate Full Time & Summer Quantatitive. Column E has
the respective Locations where each of the option in Column D are listed
(such as London only for Analyst Summer, London, Spain, Italy, France for
Analyst Full Time) and so on. The trouble is if I select Analyst Full Time
with a location of France, and then go back and change Column D to Analyst
summer, which only has London as a location, the location of France
remains
in the box when I would like it removed.

Any ideas to get this one done?

cheers