Conditional Data Validation

[Peter1999]

Hi,

Does anybody know whether you can have Excel make a Data Validatio
List based on a previous Data Validation List? That is if I select x i
A1 (as part of a DVL which consists of x,y,z,etc), that a DVL in B1 i
created with values x1,x2,x3, etc).. Thanks, that save me a lot of wor
;-)

Pete

 

[RagDyeR]

Check out this page of Debra Dalgleish on the subject of dependant lists:

http://www.contextures.com/xlDataVal02.html

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


in message
Hi,

Does anybody know whether you can have Excel make a Data Validation
List based on a previous Data Validation List? That is if I select x in
A1 (as part of a DVL which consists of x,y,z,etc), that a DVL in B1 is
created with values x1,x2,x3, etc).. Thanks, that save me a lot of work
;-)

Peter

 

[Peter1999]

Thanks for replying, RagDyer, but using this method I could only use
entries in A1:A100 that have only one word. As the data is complicated
and the file has to be user friendly, I will have to be able to use
multiple words.

If anybody has tips, thanks a lot,

Peter

 

[RagDyeR]

When you opened the link I gave you, right at the top of the page, didn't
you see a list of additional links that Debra provided for including various
types of data in your lists?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

in message
Thanks for replying, RagDyer, but using this method I could only use
entries in A1:A100 that have only one word. As the data is complicated
and the file has to be user friendly, I will have to be able to use
multiple words.

If anybody has tips, thanks a lot,

Peter