Ongoing help with dependent drop down boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pasty - 06 Nov 2006 09:52 GMT

I have used the info on this page but I can only get it to apply to the
probability and not the impact as well as I cannot re-use the names for the
risks

Pasty, have a look here,
http://www.contextures.com/xlDataVal02.html

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Pasty" <Pasty@discussions.microsoft.com> wrote in message
news:50B64BDB-FD9B-4732-8BC4-DBA51560151B@microsoft.com...

> Is there a way of having it so if people select on option on a drop down

list

> it will only give them certain options in two drop down boxes later in the
> sheet? e.g.
> If they select project risks it will only bring up options in the drop

down

> boxes relevant to them and same for bottom up risks etc.
>
> It needs to be linked into drop down boxes for impacts and probabilities
> relating to these and I need to have both because I am going to be linking

> all the different risks (group, top down, bottom up, project) to seperate
> lookup tables dependent on their outcome.
>
> I have managed to make on list dependent on this by setting up this

structure:

> Risk Probability Impact
> TDR TD1 BU1 P1 BUR BU4
> BUR TD2 BU2 P2 PR P2
> PR TD3 BU3 P3 TDR TD2
> TD4 BU4 TDR TD3
> TD5 BU5 BUR BU4
>
> With this formula:
> =OFFSET(INDIRECT($E2),0,0,COUNTA(INDIRECT($E2&"Col")),1)
>
> This allowed the probability section to work but I can't get the impact

one

> to show different bits as it involved using names for columns and cells

and I

> can't use the same names twice to refer to different impacts which would

> called:
>
> TDI1 BUI1 PI1
> TDI2 BUI2 PI2
> TDI3 BUI3 PI3
> TDI4 BUI4 PI4
> TDI5 BUI5 PI5

Reply to this Message

Bob Phillips - 06 Nov 2006 11:16 GMT

You will need to construct appropriate data for the various possibilities in
each dropdown.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I have used the info on this page but I can only get it to apply to the
> probability and not the impact as well as I cannot re-use the names for the
[quoted text clipped - 43 lines]
> > TDI4 BUI4 PI4
> > TDI5 BUI5 PI5

Reply to this Message