Posted to microsoft.public.excel.misc

external usenet poster

Posts: 54

conditional dropdown

i want to make conditional dropdown like this

if a1="x" dropdown in a2 should be US,CANADA,MEXICO
if a1="y" dropdown in a2 should be CHINA,JAPAN,INDIA,KOREA

thank you in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
How to have conditional dropdown	Ramki	Excel Worksheet Functions	1	January 5th 09 01:39 PM
Dropdown box display only data dependent on another dropdown box?	Chris	Excel Worksheet Functions	8	August 5th 08 05:01 PM
How can I use conditional formating in dropdown using named list?	Kiwi	Excel Discussion (Misc queries)	1	June 27th 08 12:55 PM
Dropdown List within a dropdown	Henn9660	Excel Worksheet Functions	1	April 10th 08 07:42 PM
offer dropdown options based on another dropdown	Conor	Excel Discussion (Misc queries)	2	January 13th 06 04:28 PM

All times are GMT +1. The time now is 08:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us