Can't Get Dependent Drop Box to Work Properly

[Robert1032]

I have watched just about every youtube video I can find, and still struggle. I can create a simple conditional drop down box (apples, oranges,etc); but whenever I try to do it with my real information, it returns the standard source effort. I have seven main choices (first drop down box); and depending on the choice selected, anywhere from 1 to 4 additional choices (second drop down box).

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[prjt]

For this method to work the titles of your lists and their content along with the titles of the subsequent categories must be identical. i.e. if your initial category list has an item called Boxes, you must make sure the Sub category list for this item is titled "Boxes", not "Crates" or "Boxez" etc.

1.
Create a separate worksheet and list out all of the dropdown menus you would like with headers>> click Formulas tab at the top>> Highlight one of your lists INCLUDING the titlksheee>> In the formulas tab click "Define Name" (The name entered automatically should be the same as the title of the list you highlighted; if it's not change it manually) and click OK>> Do this for EVERY LIST.

2.
Go to Results worksheet>> click Data tab>> Select cell you want first dropdown to appear >> click "Data Validation" in the Data tab>> select "List from the "Allow" dropdown and adjust settings to your preference (allow blanks?)>> in the Source line type =Category (Assuming that is the first list you want people to select from>> For each subsequent dropdown (so all the ones to the right) repeat this process but for the source type =INDIRECT($ COL. ROW), making the Column letter the same as the column to the LEFT of the one you are creating a new drop box in and the row number the same as the drop box before it. >> Drag down as far as you want.

NOTE: An error message will appear saying "The source currently evaluates to an error etc etc etc" That's fine, just say "Yes".

Hope that all makes sense and helps. Upload a workbook and I can give you more specific examples

[pareshj]

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/