Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down dependency stuff
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 it 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 structu 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 be called: TDI1 BUI1 PI1 TDI2 BUI2 PI2 TDI3 BUI3 PI3 TDI4 BUI4 PI4 TDI5 BUI5 PI5 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down dependency stuff
Pasty, have a look here,
http://www.contextures.com/xlDataVal02.html -- 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" wrote in message ... 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 it 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 structu 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 be called: TDI1 BUI1 PI1 TDI2 BUI2 PI2 TDI3 BUI3 PI3 TDI4 BUI4 PI4 TDI5 BUI5 PI5 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down dependency stuff
I used this for the initial list and got the dependent drop down list for
probabilities working but I can't get it to apply to impacts as well as it would involve using the same names for the columns etc. "Paul B" wrote: Pasty, have a look here, http://www.contextures.com/xlDataVal02.html -- 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" wrote in message ... 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 it 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 structu 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 be called: TDI1 BUI1 PI1 TDI2 BUI2 PI2 TDI3 BUI3 PI3 TDI4 BUI4 PI4 TDI5 BUI5 PI5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Box problem | New Users to Excel | |||
drop down then populate | Excel Discussion (Misc queries) | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions |