Make one drop down configure 3 others

[awalsh]

I have 3 drop down lists, each has percentages in at 5 percent increments that you can set up manually.

I have another drop down list that i would like for presets which will have a few choices in. Each choice gives those other 3 drop downs a different config.

E.g. "test 1" on the drop down might give us:

75
10
15

At first (to try it out on the first drop down) i just used an IF statement like:

IF(B4="test1", 75,0)

and that worked, but then if i change that percent drop manually down all that code disappears?

Any ideas how i can best use a drop down to manipulate those other drop downs? While still being able to manually affect them?

[ratcat]

G'day

Not sure what the goal(s) is but go to this fantastic web site about data validations and there is 16 examples there.

http://www.contextures.com/xlDataVal02

If there is still no resolve to your challenge, post a workbook with some manual entries of before and after.

Cheers

RC

[awalsh]

I've attached a print screen of what i'm trying to do.

Each of the "test"s in the big drop down gives a different ratio to the 3 percentages.

But note that they're not just 3 cells, they're 3 drop down lists.

I can easily make the test presets make a number appear in a cell, but not when it's a drop down list. Well, like i say, i can even do that but when i then manually go in to change said drop down list (from say 40% to 50%) all that code disappears.

Any ideas?