dependent

  1. H

    Dependent Drop Down Lists

    Hi all, hoping someone can help with this one. I'm currently working on a spreadsheet to track training data, and one thing I'd like to add is a dependent drop down list for the training provider. It would have a drop-down list in Column J to select the "Provider Type" (either external or...
  2. E

    Horizontal dependent drop down list with unequal amount of supervisors.

    Hi all, Trying to create a dependent drop down list, but ran into some issue. I want to create a drop down list that is dependent on a previous drop down list. The first drop down list includes the management unit, which is already working fine. For that I created a small macro that retrieves...
  3. Akuini

    3 or More Dependent Data Validation, with VBA, easy to set up

    I want to share a macro to set up multi dependent data validation with vba. Some versions of dependent data validation use formulas to set them up, usually with indirect functions. For 2 or 3 dependent data validation & small data set, it's pretty easy to set it up, but for more than 3, it might...
  4. D

    making excel recognize it's 20XX not 19XX

    is there a simple way to do this so that it's not PC dependent ? change the settings within the workbook? rather not use formulas
  5. C

    Dropdown menus dependent on another cell being <8.0 or >8.0

    Hello - I've created a timesheet for my employees in Excel. I'd like there to be one particular dropdown menu that shows if the total hours for a day are less than 8.0, and another dropdown to show if the hours are more than 8.0. I know how to do dependent lists, but not how to make a list...
  6. J

    Userform dependent combo boxes

    Have the following code to try that attempts to allow you to use the drop down in a userform which is dependent on the other. It is setup with an advanced filter in the spreadsheet. The problem I am encountering is that nothing shows in the dropdown box (combo box1), any ideas? Thanks. Private...
  7. Z

    Issue drop down menu indirect from offset table

    Hi, I cant seem to resolve this: I have made some tables i wish to use in two drop down list with the one list dependent of the choice of the other(indirect formula) The lists is made by using the offset and antalla fomula to avoid emtpy cells in lists. My problem is that when i want to make...
  8. T

    Does this shortcut exist? Jump to precedent/dependent cell on another sheet

    Hey Mr Excel users, I'm looking for a shortcut that allows me to jump to dependent or precedent cells on other sheets. I know you can do it within the same sheet, but hate having to manually click that arrow that pops up when the cell being traced has a dependent / precedent on another sheet...
  9. E

    Workday formula required based on depending dates

    Hi Team :) I have below data and im using formula =WORKDAY(C2,1) to calculate the workdate based on the received date. However, I have 3 depending activities for which the workday should calculate only after the depending task is completed. and it will be next workday after the depending task...
  10. E

    Illegal Characters in Drop downs

    Hey everyone, Does anyone know how to use illegal characters in a Drop down? I have looked it up, but everything I have read went over my head. I have a a drop down that is dependent on a drop down. In the first drop down I have a few fractions that need to be options. Thanks for the help.
  11. H

    Data Validation Dependent Drop Down 2 Criteria

    Hello Friends, I am using the below formula in data validation to get the dependent drop down list =OFFSET('SIZE ORDER'!$B$1,MATCH(A2,so_ref_no,0),0,COUNTIF(so_ref_no,A2),1) I just want to add another criteria Match(C2,so_size Please if anyone can add the 2nd criteria in the above formula...
  12. O

    perform calc based on if other cells are populated

    I am wondering if anyone has any suggestions to assist me with my problem. Below is a sample of what my data looks like. A B C D E F G H I J 62 Shop 456.20 NO YES NA NA NA Overtime 63 Check 8756.00 YES NA...
  13. E

    Resetting Dependent Dropdown Lists

    I realize that this question has been asked and answered previously - however, for the life of me I cannot figure out why the below code isn't working in my case. My parent drop down list exists in column D (various rows) and my dependent list exists in column F (again various rows...
  14. T

    How to test whether a single-cell range is a dependent (first-order, second-order, ... n-th order) of a given range (single cell or multiple)?

    Hello MrExcel gurus, The title of this post has the jist of my question, but here's a bit of background: I'm trying to optimize a very bulky financial model. I've got calculation time down to a couple seconds or so, but I'd like to isolate the specific cells whose calculations are still...
  15. D

    VBA code to reset dependent dropdown

    Hello, I've got a workbook I've been working on with primary drop-downs located in col G, cells 13, 14, 15,(merged cell with H&I), my dependent drop-down is in C of the same rows. (Merged cell with D). Despite trying codes copied from forums here and adjusting the locations to my situation, I...
  16. G

    syntax dependent on values of multiple comboboxes

    Hi All, Is anyone able to help me with the below? I need the values in blue to refer to the result on Combobox17, and the values in red to depend on the result of combobox5 If Sheets("changes dependent on combobox17").Cells(i, "A").Value = (Me.TextBox101) Or _ Sheets("changes dependent on...
  17. A

    UserForm dependent upon cell content. Now opens every time any cell is selected the userform opens again.

    I have it so that the userform only shows when "XYZ" is selected from a drop down in B2. But now even after it is satisfied if I select any other drop down in any other cell of this worksheet the userform opens again. I only want it to open if "XYZ" is selected from B4. Private Sub...
  18. S

    Dependent drop down list using activeX combo box

    Hi,I am in need of someone to solve a problem with dependent drop down lists using activeX combo boxes. Below are links to 2 files that are set up with data validation lists. Starting in cell B24 is the main list of fabric types and in cell D24 is the dependent list of fabric colors. In the...
  19. R

    Dependent validation list with table as source

    Hi all, Could not find the solution elsewhere that combines my following questions, so I hope one of you has the solution! I am trying to dependent validation list, where the source data is in one table (A1:C14). The table headers are generic and so cannot be used to refer to for the second...
  20. Roderick_E

    Slicer Scroll to selected

    So, if you have one slicer that controls another, is it possible to force the dependent slicer to scroll to the selection? It looks like someone tried an answer previously: https://www.mrexcel.com/forum/excel-questions/895324-vba-scroll-slicer-possible.html?highlight=slicer+scroll EXAMPLE...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top