Drop Down Selection Assistance

[matgriffey]

Good afternoon
I have a workbook that I am attempting to make drop down boxes in tha
allows a user to go in and select item one (DIV), then have the nex
drop down box give the options based on item one, as item two (BILLTO)
Based on the selection in item two, the next box would return the LEVE
for item two. I have figured out how to make a cell calculate th
appropriate LEVEL based on what is in item two BILLTO (using VLOOKUP)
What I can not get is the DIV to be selected, The BILLTO to be a dro
down selection option based on the DIV, then the LEVEL populate based o
BILL TO. If this is something that can be done, please let me know ho
to do so, or direct me where I can go to find this solution. I hav
attached the root information in case this will help.
Thank Yo

+-------------------------------------------------------------------
|Filename: Help Test.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=686
+-------------------------------------------------------------------

 

[lhkittle]

Good afternoon

I have a workbook that I am attempting to make drop down boxes in that

allows a user to go in and select item one (DIV), then have the next

drop down box give the options based on item one, as item two (BILLTO).

Based on the selection in item two, the next box would return the LEVEL

for item two. I have figured out how to make a cell calculate the

appropriate LEVEL based on what is in item two BILLTO (using VLOOKUP).

What I can not get is the DIV to be selected, The BILLTO to be a drop

down selection option based on the DIV, then the LEVEL populate based on

BILL TO. If this is something that can be done, please let me know how

to do so, or direct me where I can go to find this solution. I have

attached the root information in case this will help.

Thank You





+-------------------------------------------------------------------+

|Filename: Help Test.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=686|

+-------------------------------------------------------------------+

Hi matgriffey
Take a look at these sites for dependent drop downs.

http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal02.html
http://excelsemipro.com/2011/05/a-dynamic-dependent-drop-down-list-in-excel/

HTH
Regards,
Howard

 

[matgriffey]

Hi matgriffey
Take a look at these sites for dependent drop downs.

http://www.contextures.com/xlDataVal13.html[/URL]
http://www.contextures.com/xlDataVal02.html
http://tinyurl.com/d7kbpo9

HTH
Regards,
Howard

Thank you very much for your assistance Howard. I appreciate th
information. Have a great day.
Mathe

+-------------------------------------------------------------------
+-------------------------------------------------------------------