Auto Populate Drop List from a selection in another Drop List

[cproskie]

Hey I'm really hoping someone can help me out with this one.

Basically what I'm trying to do is create a drop list depending on the option selected on another drop list. I think the main issue I'm having is that the option list is on another Sheet and excel keeps telling me I can't do a DataValidation from another Sheet for my Drop List Box.

For example lets say I'm creating a order form for clothing. If someone selects 'T-Shirt' from a drop list box I would like the next box to create another drop list box that would have size options.

User Selects 'T-Shirt'
Sheet creates drop list box that has options listed in another Sheet, 'Small' 'Medium' 'Large'

I've been looking at this for a couple hours now and can't come up with anything that works. Hope someone out there has an idea how to make this work

Chris

 

[hiker95]

cproskie,

Welcome to the MrExcel forum.


See if the following will help you:

Excel Data Validation -- Dependent Dropdowns from a Sorted List
http://www.contextures.com/xldataval13.html

Set up the Workbook
Two worksheets are required in this workbook.
Delete all sheets except Sheet1 and Sheet2
Rename Sheet1 as ValidationSample
Rename Sheet2 as ValidationLists