Prev: inventory
Next: Top 10 in pivot - show rest as other or similar
From: moonhkt on 5 May 2010 00:21
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
From: ozgrid.com on 5 May 2010 00:25
See http://www.ozgrid.com/Excel/dependent-lists.htm



--
Regards
Dave Hawley
www.ozgrid.com
"moonhkt" <moonhkt(a)gmail.com> wrote in message
news:f9e6072d-b165-4d95-85a0-a4b2984c10a6(a)s13g2000prc.googlegroups.com...
> 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

From: Roger Govier on 5 May 2010 03:33
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
 | 
Pages: 1
Prev: inventory
Next: Top 10 in pivot - show rest as other or similar