Lucas,

There is an example at http://www.contextures.com/xlDataVal02.html on how to
do this.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"lucas" wrote in message
...
Hi!

I'd very much appreciate any hint for the following issue:

Let's say In cell A1 I can choose between 'boy' and 'girl'.

Names available for boys a Jon, Tom and Ben while for girls: Claudia,
Pamela and Sarah.

In cell B2 I'd like to create choice list (by data - validation - list)
with reference to value in cell A1.

I don't know how to narrow the choice in drop-down menu in cell B2 with
reference to value of cell A1.

Thx in advance for any help!

lucas