data validation on sth else
 

Hi,

I'd like use data validation by insert data in empty sheet
(for two columns).
My data is in two define name: Name1 and Name2
In Name1 i have at choice data: "a", "b", "c"
Name2 is dependent on Name1 e.g. if i insert in cell "a"
then i'd like to have in next cell option only for
data "a".

Show result:

Name1 Name2
a a25
a ac2
a op
b b2
b b8
b ty

How have I resolve my problem?
I use excel 2k.

Regards
Mark

Try Debra Dalgleish's nice coverage of "Create Dependent Lists" at:
http://www.contextures.com/xlDataVal02.html

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
" wrote in
message ...
Hi,

I'd like use data validation by insert data in empty sheet
(for two columns).
My data is in two define name: Name1 and Name2
In Name1 i have at choice data: "a", "b", "c"
Name2 is dependent on Name1 e.g. if i insert in cell "a"
then i'd like to have in next cell option only for
data "a".

Show result:

Name1 Name2
a a25
a ac2
a op
b b2
b b8
b ty

How have I resolve my problem?
I use excel 2k.

Regards
Mark