dependant drop down list

Good afternoon everyone! I've got a weird one that I can't find anything for, nothing to even read up on so hoping one of you wizards can help! I'm simply wanting to make a dependent dropdown list where a date is chosen in one cell, then in the next cell a series of (numerical) values will be...

i have a file containing the sample userform of 3 sample combo boxes every next combobox is dependant to the previous. there is a simple vba behind it, which i think should work correctly. Option Explicit Private Sub UserForm_Initialize() ' set worksheet Dim sh As Worksheet Set sh =...

Hi I have a rules database 4 columns, circa 500 rows(all cells populated). Column D has ALL unique values(the rules) Column A 37 unique values,B and C similar(the descriptors). If you want to find a rule in column D you use A-C to narrow down the search. Easy with filters, but I want to build...

<colgroup><col span="7"></colgroup><tbody> Model spec colour model 1 a b c white black grey model 2 a d e green white blue model 3 c f g yellow red black </tbody> Is that anyway to create the 2nd(spec) and 3rd(colour) drop down list base on the selection of 1st drop downlist(Model)?

I have a problem trying to create a data validation list from matching data in an adjacent cell to an unsorted 2 column list on another sheet. First sheet - Reference column A to return column B <tbody> A B 1 ROOM ELEVATION 2 Study Rear 3 Living room front 4 Study Rear...

Good morning, I am wondering if it would be possible for a cell to contain a specific drop down list, but only if the adjacent cell is 'not blank'. For example, Cell B2 would have a dropdown of 'Yes and No' only if the result in A1 is 'Not Blank'. Cell A1 contains a formula that selects...

Hi All, I've been trying to find an array formula for a dependant drop down list I saw a few years ago. Basically, I have three Source columns (Category, SubCategory, Details) that I need to work with. Constraints: Must not use VBA, Helper Columns, Macros Source is not defined as a Table...

I wanted to make a drop down userform with 3 levels. (Level 1 decides Level 2 decides Level 3). The goal is to have the users of the form be able to select from drop downs to get to level 3 instead of having to look through all the level 3 items. I was able to get 1 and 2 to work however...

Hi I am trying to create a 3-tier dependant dropdown list system Dropdown 1 = Supplier (Many of) Dropdown 2 = Material Type (Approx 20 of, but not all suppliers supply all materials) Dropdown 3 - Material grade (Many of but Unique to supplier/material combo - eg Material grade ABC123 is...

So i've gotten my code to work and it works great BUT it's going to be VERY long. At the end I'll have like 80+ Case indexs (I have to copy the code about 80 times and change the range.) Is there a shorter way to do this? I can change the data on the sheet into tables or something and name...

Hi all, In my Excel 2010 workbook I have created some dependant drop-down lists. On a hidden sheet called 'Background Data' I have the various dependencies set out in tables which have been given named ranges. Initially everything was working fine on my test data, but when I started adding in...

Is there any way to create dependent drop down list for data validation without indirect function because indirect function is not working on my excel 2013. I have no idea why it is not working.. it returns the result as error. Please help.....

Hello; I want to do a drop-down menu that depends on another drop-down menu. Besides, the list should be dynamic, i.e., I should be able to add more elements. I use the name manager and add the =OFFSET(...;0;0;COUNTA(...)) do make the lists dynamic. I don't know why, but it doesn't work. I...

Hi guys, I have had a look for answers to this problem and keep getting stuck. I will try to simplify the scenario. I need to generate a dependant list, however the first range has cells with illegal characters (&) and multiple words. I'm not sure which is causing me problems to be honest...

Hi, I am new to using Macros and data validation and have run into a problem i am hoping someone can help with. I am trying to create a macro for estimating purposes that will contain a dependent data validation. The dependent validation will work if i use a direct reference in the second...

Helloo, I would like to create an automatic and manual setting in my latest spreadsheet. The operation mode is a drop down list. When Automatic Input is selected, then the engine type and load will be a drop down list also. However, when the Operation Mode is in Manual Input, is there a way of...

Hi everyone, I'm trying to create a workbook for my job and create multiple drop downs using data validation, but using a single source (another drop down as my trigger for my dependant lists). Here's my data: <TBODY> Investor</SPAN> Claim</SPAN> Fees due</SPAN> Amortization</SPAN>...

Hi As a long time reader of this site and of course utilizer of its very helpful code snippets, this is my first post. I have a rather interesting problem that I am trying to resolve in Excel. Currently, I have 3 columns of data (actually folder names) that I want to use to populate...

Hello All. I have the following situation in a spreadsheet (Excel 2007): Sheet1 Column A = Project Column B = Products Column C = Suppliers In Sheet2, I need to create 3 drop down lists (Project / Products / Suppliers), that every time I select a Project, only displays the products and...