Conditional Validation
 

Hi,

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

Can anyone help?!


--
TTomSawyer
------------------------------------------------------------------------
TTomSawyer's Profile: http://www.excelforum.com/member.php...o&userid=20511
View this thread: http://www.excelforum.com/showthread...hreadid=395193

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

"TTomSawyer" wrote
in message ...

Hi,

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

Can anyone help?!


--
TTomSawyer
------------------------------------------------------------------------
TTomSawyer's Profile:
http://www.excelforum.com/member.php...o&userid=20511
View this thread: http://www.excelforum.com/showthread...hreadid=395193