Successive Data Validation Lists

[monir]

I've recently developed and programmed 5 analytical procedures in Excel
environment (XL 2003, Windows XP).
For simplicity, let us assume that the following depicts the applicability
of the 5 packages:
SERIES FOR INFLOW PROGRAM

Series_1........Prop............Uniform...............BS.xls

Series_2........Prop.......Steady Co-Axial.........GS-Stdy-Prop.xls
Series_2........Cav........Steady Co-Axial.........GS-Stdy-Cav.xls

Series_2........Prop.......Unsteady Periodic......GS-Unstdy-Prop.xls
Series_2........Cav........Unsteady Periodic......GS-Unstdy-Cav.xls

The 5 XL files reside in a common folder.

The data validation list under SERIES would have Series_1, Series_2.
The list under FOR depends on the selected item under SERIES.
The list under INFLOW depends on the selected item under FOR.
The displayed file name under PROGRAM dependes on the selected item under
INFLOW. Then click and open the file, if so desired.

For example, if the following selections are made: "Series_2" "Prop"
and "Unsteady Periodic", the file name "GS-Unstdy-Prop.xls" should appear
under PROGRAM. Then click to open the file.

One perhaps could use Excel nested conditional IF statements to sort out the
applicable lists. Another approach would be to use data AutoFilter.

Can you think of a more elegant way?

Any suggestions? Thank you.

[Casey]

Try Debra Dalgleish's website. the following link with take you to a section which I believe has what you want.

http://www.contextures.com/xlDataVal02.html

HTH

[Debra Dalgleish]

There are instructions here for dependent data validation lists:

http://www.contextures.com/xlDataVal02.html


monir wrote:
> I've recently developed and programmed 5 analytical procedures in Excel
> environment (XL 2003, Windows XP).
> For simplicity, let us assume that the following depicts the applicability
> of the 5 packages:
> SERIES FOR INFLOW PROGRAM
>
> Series_1........Prop............Uniform...............BS.xls
>
> Series_2........Prop.......Steady Co-Axial.........GS-Stdy-Prop.xls
> Series_2........Cav........Steady Co-Axial.........GS-Stdy-Cav.xls
>
> Series_2........Prop.......Unsteady Periodic......GS-Unstdy-Prop.xls
> Series_2........Cav........Unsteady Periodic......GS-Unstdy-Cav.xls
>
> The 5 XL files reside in a common folder.
>
> The data validation list under SERIES would have Series_1, Series_2.
> The list under FOR depends on the selected item under SERIES.
> The list under INFLOW depends on the selected item under FOR.
> The displayed file name under PROGRAM dependes on the selected item under
> INFLOW. Then click and open the file, if so desired.
>
> For example, if the following selections are made: "Series_2" "Prop"
> and "Unsteady Periodic", the file name "GS-Unstdy-Prop.xls" should appear
> under PROGRAM. Then click to open the file.
>
> One perhaps could use Excel nested conditional IF statements to sort out the
> applicable lists. Another approach would be to use data AutoFilter.
>
> Can you think of a more elegant way?
>
> Any suggestions? Thank you.
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[monir]

Debra;
Thank you. The link is helpful!


"Debra Dalgleish" wrote:

> There are instructions here for dependent data validation lists:
>
> http://www.contextures.com/xlDataVal02.html
>
>
> monir wrote:
> > I've recently developed and programmed 5 analytical procedures in Excel
> > environment (XL 2003, Windows XP).
> > For simplicity, let us assume that the following depicts the applicability
> > of the 5 packages:
> > SERIES FOR INFLOW PROGRAM
> >
> > Series_1........Prop............Uniform...............BS.xls
> >
> > Series_2........Prop.......Steady Co-Axial.........GS-Stdy-Prop.xls
> > Series_2........Cav........Steady Co-Axial.........GS-Stdy-Cav.xls
> >
> > Series_2........Prop.......Unsteady Periodic......GS-Unstdy-Prop.xls
> > Series_2........Cav........Unsteady Periodic......GS-Unstdy-Cav.xls
> >
> > The 5 XL files reside in a common folder.
> >
> > The data validation list under SERIES would have Series_1, Series_2.
> > The list under FOR depends on the selected item under SERIES.
> > The list under INFLOW depends on the selected item under FOR.
> > The displayed file name under PROGRAM dependes on the selected item under
> > INFLOW. Then click and open the file, if so desired.
> >
> > For example, if the following selections are made: "Series_2" "Prop"
> > and "Unsteady Periodic", the file name "GS-Unstdy-Prop.xls" should appear
> > under PROGRAM. Then click to open the file.
> >
> > One perhaps could use Excel nested conditional IF statements to sort out the
> > applicable lists. Another approach would be to use data AutoFilter.
> >
> > Can you think of a more elegant way?
> >
> > Any suggestions? Thank you.
> >
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>