Conditional Validation

[TTomSawyer]

Hi,

I would like to have conditional validation in a worksheet...
basically, if someone selects 1000 in one box, the validation i
another box says "1010, 1020" - based on a list i have created, THEN i
someone changes the first box to say, 2000, the validation changes t
"2010, 2020, 2939" - again, based on another part of the same list, o
a different list...

Can anyone help?

 

[Paul B]

TTom, see if this will do what you want,

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003