dependent

Here's another one that I can't seem to find anywhere. I am not looking for nested validation or dependent drop downs, I know how to do that. Maybe what I want is simpler but I'm just not seeing a solution... I have attached a sample worksheet. What I want is a self-populating list that is...

Good day all! I am using the below code in a large project. My dependent cells have formulas in them with several resulting in a blank "" cell. I believe Error 1004 no cells were found occurs if a dependent cell is blank. I'm new to VBA, and assuming it would be better to change my code to...

I have 4 columns with costs for 2015,2016, 2017 & MAX Value I want to apply and % uplift to the MAX value column but this could be in any of the 3 columns. The % Uplift varies dependent upon what year the MAX value is in. Col 1; Col 2; Col 3; Col 4 2015; 2016; 2017; Max Value 8.07%;6.65%;3.95%...

I have created (with a lot of help from this site) a cascading dependent drop down list set. The problem I am having now is I would like to make another INDEX MATCH formula to grab an image that is dependent on the two drop downs. I have been trying for well over 4 hours now and still cannot...

Hi, Can I please pick your brains for some much needed excel help I am trying to set up data validation using dependent drop down lists, of which this is simple as long as you can define the names the same as the headings for each "dependent list" There is my issue, each of my headings may...

Hi, I'll try to explain it with the help of the table at the end of this message. I want to "pull" only these values of column Y (for a value comparison in a different table) that are dependent on the same value in column X. In the table, the first four values in column Y have got the same X...

I can find similar posts on the forum but not exactly what I would require. I have exhausted all of my slim knowledge in both Excel and VBA in trying to complete the task so please is there someone out there who can help? I have a spreadsheet and in column B2 it would show a numerical value...

Hi all, I am working on a form that includes product selection through drop-down menus. It starts off with a product category, a chosen category predefines a choice of product names. After choosing a product name, the user needs to select two parameters which both depend on the product name. My...

I have 8 lists of data in columns F1-13 through M1-13. What I need to do is make a data validation list in column C and D. Column C should be able to select ANY of the data from the 8 columns, Column D needs to be dependent on column C. If the data in column C is from column F or G then the data...

Need help on the following scenario. I am trying to use the below formula but I cant make it work. =VLOOKUP(A2,INDIRECT("'C:\Source\["&C2&".xlsx]Sheet1"&"'!"&"$A:$D"),4,0) I have a masterfile that looks like this. <tbody> Task ID Team Ops Status 123 A Michael Completed1 456 C Jude...

Okay so this has been picking at my brain for sometime now... Can anyone help me out with this, here is what I have so far. "=if(C2,">=1","")HYPERLINK(B2))"

I am having a problem with dependent validated options using INDIRECT. Please see illustration. https://www.dropbox.com/s/fnlyewqsux7rh0k/Indirect_validation.xlsm.png The goal is to make the valid options offered in column I dependent on the selection made in column H, using =INDIRECT(A2) to...

Hi, I am looking to combine a drop-down list with a range of editable data that can then be saved and later loaded (if possible). What I mean exactly by this is to first have a single drop down list containing all of the calendar months of the year. A range of data (dates, vendors, costs, and...

Hi Guys, First of all, I would like mention that my knowledge in Excel formulas is limited to basic functions. My request might seem easy but I could not figure it out. I have two dropdown lists. The fist one is straight forward and gives a list of equipment. The second one is dependent on...

Good evening. The spreadsheet I've been working on is for my students to use as their training log. I've been trying to make the lists in the column of Exercise 1 and 2 dependent on the Training Split. Meaning when a person picks a training split like Legs And Back or Flexibility, all the...

I'm working with data where I have 2 areas, each with multiple regions, then each region with multiple markets. I'd like to have the user select from the 1st dropdown of 'areas', then the regions available to choose from in the next dropdown will be dependent on the area(s) selected, and the...

Hello every one. I try to make a dependent combo box but are not be able to solve my difficulties. That its not dependent.

hi, i have the below code to clear value of Dependent drop downs (C13:C22) when selection changes in parent drop downs(B12:B22) but i have an issue. i have rows with some data above B13 and when there is a change in the any of cell between B1 to B12 the corresponding column values are also...

I need to put range A9:E9 in A1 causing last line (A5:E5) to say Bye Bye,leaving its place to the new data set I did it with a macro ,but it makes formulas in dependent cells to produce #errors Can I get some help ,thanks for your kindness [/URL][/IMG]

Hello, I work in the IT department at my job and we have these large excel spreadsheets that our are "employee templates." These are to help us know which employees in which departments are to get what applications, access, etc. I am currently working on making these templates more user...