Auto Populate Drop List from a selection in another Drop List

cproskie

New Member
Joined
Jan 24, 2012
Messages
2
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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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
 
Upvote 0

Forum statistics

Threads
1,212,929
Messages
6,110,740
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top