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 |
conditional dropdown
Dear Aditya
The below link on dependent list will definitely help http://contextures.com/xlDataVal02.html If this post helps click Yes --------------- Jacob Skaria "aditya" wrote: 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 |
conditional dropdown
Aditya, you can also refer the below which explains about dependent dropdowns
from * a * sorted list... http://contextures.com/xlDataVal13.html If this post helps click Yes --------------- Jacob Skaria "aditya" wrote: 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 |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com