Menu

Conditional Data Validation

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

Conditional Data Validation

Look here
http://www.contextures.com/tiptech.html

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Xanoca" wrote in message
...
I am having a problem in how to set the following Data Validation list.
I have two columns that will be fill-in by the users. And I want that the
drop down list in the second column will be connected with the selection
made
from the user in the first column.
Ex:
First Column Drop down list: windows, doors, walls
Second Column Drop down list:
- if in the 1 column was inputed "widows", then it will show the drop
down list: glass, plastic, cristal
- if in the 1 column was inputed "doors", then it will show the drop
down
list: wood, metal
- if in the 1 column was inputed "walls", then it will show the drop
down
list: tiles, pladour, bricks

Can you tell me, how can I do this?
Regards

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Data Validation	Walt Herman	Excel Worksheet Functions	5	October 31st 07 08:58 PM
Conditional data validation.	Dolphy	Excel Discussion (Misc queries)	3	October 9th 07 05:04 AM
Data Validation & Conditional Formatting	Shelly	Excel Discussion (Misc queries)	3	December 22nd 06 08:23 PM
Conditional Data Validation	Peter1999	Excel Discussion (Misc queries)	3	May 3rd 06 03:54 PM
conditional data validation	RickS	Excel Worksheet Functions	6	December 16th 05 01:11 PM

All times are GMT +1. The time now is 05:14 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement