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!
================================================== ===


"Peter1999" wrote
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
------------------------------------------------------------------------
Peter1999's Profile:
http://www.excelforum.com/member.php...o&userid=33997
View this thread: http://www.excelforum.com/showthread...hreadid=538459