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.

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

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