Conditional Validation

  • Thread starter Thread starter TTomSawyer
  • Start date Start date
T

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Validation 3
IF + respective Validation Dropdown List 2
Conditional Validation 3
Usage of Data Validation with If Condition 4
frustrated excel newbie 2
Validation in a Conditional Statement 2
Data Validation Restriction Referencing other Workbook 1
Problem with data validation 2

Back
Top