Hi,
I need to create a dropdown list which will be dependent on the inputs in the previous cells.
Attaching the sample file.
In this, If I select M14 as bolt size, only 2, 1.5 and 1.25 should come as Pitch, and if I select 1.25 as pitch size, in the next dropdown, bolt number dropdown should only be A915991. like it continues.
Can u pls help
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
this should help..
http://www.contextures.com/xlDataVal02.html
Life's a spreadsheet, Excel!
Say thanks, Click *
WOW...
that worked... Thanks..
It is very simple to create dependent drop down list in excel. Check out the below link and follow the steps,
http://snpinfotech.wordpress.com/201...ists-in-excel/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks