About Data Validation

Hi All
I have excel worksheet using Data Validation for control input Value.

In the raw data sheet, Define some Name e.g. "DBNAME", AREA","TABLE
Name" range

It is possible select one DBNAME value, just allow select a particluar
list of AREA and TABLE NAME ?

e.g.
DBNAME AREA Table NAME
DB1 A1 T1
DB2 A2 T2
DB3 A3 T3
A4 T4
A5 T5
T6
e.g.
When select DB1 just allow user select A1, A2 and select T1,T2,T3
When select DB2 just allow user select A3, A4 and select T3,T4

moonhkt

See http://www.ozgrid.com/Excel/dependent-lists.htm



--
Regards
Dave Hawley
www.ozgrid.com
"moonhkt" wrote in message
...
Hi All
I have excel worksheet using Data Validation for control input Value.

In the raw data sheet, Define some Name e.g. "DBNAME", AREA","TABLE
Name" range

It is possible select one DBNAME value, just allow select a particluar
list of AREA and TABLE NAME ?

e.g.
DBNAME AREA Table NAME
DB1 A1 T1
DB2 A2 T2
DB3 A3 T3
A4 T4
A5 T5
T6
e.g.
When select DB1 just allow user select A1, A2 and select T1,T2,T3
When select DB2 just allow user select A3, A4 and select T3,T4

moonhkt

Hi

Take a look at a tutorial I wrote at
http://www.contextures.com/xlDataVal15.html
There is also a downloadable example file
--
Regards
Roger Govier

moonhkt wrote:
Hi All
I have excel worksheet using Data Validation for control input Value.

In the raw data sheet, Define some Name e.g. "DBNAME", AREA","TABLE
Name" range

It is possible select one DBNAME value, just allow select a particluar
list of AREA and TABLE NAME ?

e.g.
DBNAME AREA Table NAME
DB1 A1 T1
DB2 A2 T2
DB3 A3 T3
A4 T4
A5 T5
T6
e.g.
When select DB1 just allow user select A1, A2 and select T1,T2,T3
When select DB2 just allow user select A3, A4 and select T3,T4

moonhkt