dependent

Hi, I am trying to figure out a problem with dependent drop down lists boxes using data validation. I made the formula below following a tutorial online - I named this formula in name manager and used the name in the data validation source box. My main drop down list is in B24 and the second...

I have set this up numerous times by searching for Dependent Drop-down list and following the instructions. This works well when using only two cells, one for the category, and one for the items in the category. I'm having a hard time translating that when I want the category in column D and...

I love the "Trace Dependents" function in Excel but it has a significant limitation. I have to click on every single cell individually to see if it has a dependent. Is there a way to select an entire range of cells and see which of them has one? I don't even need to know what the dependents...

Hi guys, I have a form I created for our department that has dependent drop down lists that I have cobbled together that is barely held together with spit and duct tape :) But I am having some issues creating another set of dependent drop down lists. I have three section with dependent lists...

I would like to modify my existing drop down lists to dependent ones. I have followed some of the online tutorials and made some of my own samples to learn how do make a basic dependent one. I would like to know if something is possible and below is a small sample of what I am working with...

https://drive.google.com/open?id=1z7JllULnypzq2qdpSXaUZqJhjQjuobXdiVCzOE1vsjY Hello, I'm trying to make a dependent dropdown list in the "Model" section B1, in A1 a drop down has been created and I defined a name on the Formulas tab, create from selection tab. On the data validation, I am...

I have a couple of non public IPs. I have a programme that uses 1 of 2. I need to detect if either is available, and if not ensure my functions do not run (The whole thing goes really really slow). I haven't found anything simple that will do what I am looking for, anyone point me to something...

Dear All, Thanks for reading. I am wondering if anyone could help me write a macro in order to loop the regression function. I have a total of 56 dependent variables and 3 independent variables which remain constant for all the regressions. Every regression is just using the next column for...

Hi I'm trying the get a dropdown to autofill and read that a combobox would be the best solution. What i'm struggling with is that my dropdown range is dependent of an input in another cell - it's dynamic, based on which value i chose. When i insert a combobox the values i can choose in it is...

Hi all, I'm somewhat new to this linked drop down lists thing and I'm having a little problem with it. I was able to make two dependent lists that work really nice when I'm first selecting the options as you can see in this first picture: But then, when I change the value in the first list...

Hi everyone. I have a bunch of information in a single table. I want to use 2 drop-downs and then a Vlookup with indirect function to call that data out on another part of the sheet. Everything that I've seen so far shows making dependent lookups based on making multiple tables. I can't do...

Good day to all of you VBA masters! Dependent dropdowns in userform are the bane of my existence and make me very.....very sad. But they are super useful and I once again need help in writing the code for it. So I have a Table laid out like below; Table1 <TBODY> 1a a 1a aa 1a aaa 2b b...

Good day! Looking for some help in creating a dependent dropdown (combo box) on a User from. The Named Ranges are being pulled from tables. Basically it needs to run like this; If ExpIncDrop (Combo box) = "Expense" Then TypeDrop (Combo box) = ExpenseType (Defined Named Range) Else TypeDrop...

Is it possible to colour cells dependent on values? On even rows (starting row 2) - Columns C:F - If "Yes" 169,208,12. If "No" 198,224,180 On odd rows (starting row 3) - Columns C:F -If "Yes" 155, 194, 230. If "No" 189, 215, 238 Finishing row 479

Hello, I am trying to create a shared spreadsheet where users can select an original value from a drop down listing, and then fill out remaining information using additional drop down listings that are dependent upon the original drop down listing. There is one catch. The dependent drop down...

I have a dependent drop down set and it is working fine in the first cell of worksheet 2. Now I want it to work for the other cells down the column. I am using the following: =INDIRECT($E$2) Cell E2 is a drop down list from sheet 1 I want the dependent drop down for the entire column (F)...

Hi All, I am not entirely sure how I should go about accomplishing this because I believe there are a few ways to do this. I have a list of data similar to below: 0582 051 0582 954 0582 725 1275 654 1275 777 5290 936 5290 003 5290 051 5290 923 5290 000...

I have created a dependent list which will display selected values based on the parent list. Now I am looking for a option to clear the contents in dependent list when i change the selection in the parent list. Ex: Column K2 to K400 i have the parent list (Transport, Admin, HR) Column L2 to...

I need help creating a dashboard that contains 3 Comboboxs that then cascades through selection down to the resulting machines test results. EX: Bulldozer > John Deere > 750K or Excavator > CAT > D264 My excel workbook is comprised of Multiple sheets for every type of construction machine...

Hello! I need to create an excel sheet that will be filled in by individuals but the contents of the sheet are dependent on the answer of cell B2. If B2 is Yes then the below is displayed: <tbody> Credit Yes Name Surname Address </tbody> If B2 is No then the below is...