About Data Validation

M

moonhkt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top