dependant values

  1. C

    UserForm ListBoxes Dependant Selections

    Hi All, I am creating a couple of listboxes for my users. The first listbox is a list of clients. The second list is a list of projects. I have a separate macro running to copy and paste some data depending on the users' selections. I need to give the users the ability to run either a...
  2. A

    Need help with Data Validation

    The problem i'm facing is that C8, C9, and C10 all have to be positive values and less than C4+C5. That part I've figured out and is fine but the problem is that C9 has to be greater than C10. I set it so C9 has to be between the above restrictions and set C10 so the minimum is C9. The...
  3. M

    Need Help

    Hello! I am trying to come up with a code that does the following things: I have two sheets, sheet "RESUMO" and sheet "Gran.Solos NLT 10491". Each sheet has a cell named "Sample" next to which the sample number is written. In sheet resumo there is a column full of sample numbers, and I need for...
  4. K

    Display different lists based on conditions in a dropdown menu

    Could anyone point me in the right direction, please? I have a list with teamnames for my local poolcompetition. And, thanks for asking, mainly straight and 8-ball ;). Now, I use this list as input for a validation drop down list. Now comes the tricky part: for every team i have a list of...
  5. ClimoC

    Sticky: Display Named Range contents based on text in cell

    Hey Excellers... I have some dynamic named ranges in sheet1, and in sheet2 I have data validation dropdown list which has the names of all the DNR's in it. What I want it to do (in sheet3, no less) is for the user to be able to pick a named range from the dropdown list, and have a particular...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top