validation lists

  1. A

    Chart data change via selected named range(s) in validation cell...help please...

    Hello all - I am hoping someone may have some input on this, please: I have created 5 named ranges from a table. Each named range is simply one column of data. Then created a lookup for the (names of) these named ranges (names match exactly, etc.) Once I had a lookup list, I then created a...
  2. J

    Validation on multiple column

    Good afternoon everyone, I thought I knew how to do this but seems not, I am trying to validate a cell value to see if it's in a name ranged and check if the cell above is the offset of the named ranged. here is an example of what I have: On sheet1 I have the following: Cell C6 contain a...
  3. T

    Userform to add names to a validation list for a cell.

    Good Day Folks! I am attempting to create a form which uses a validation list for cell A2. I have created the list I want to use in range H2:H5. That part is easy. The hard part is that several folks that have limited Excel skills may need to add new names as new people are needed on the...
  4. D

    Adding a function to select from a validation list within a macro.

    Hi all, I have a macro that copies values from one sheet (1) and pastes them into another sheet(2). However in sheet 2 there are 3 validation lists that I need the macro to select from based on other values in sheet 1. Recording the macro to copy and paste values and then loop it down the...
  5. M

    Validation lists needed to autopopulate, or not

    The goal is for efficiency. The user wants to have the options to: 1. Select component-by-component or, 2. Select a kit. In 7 of 10 times, a Kit is going to be ordered. My thought is to add a dropdown list in Column F that offers: - Component - Kit A - Kit B - Kit C If "Component" is...
  6. B

    Reset dependant validation list when preceeding validation list is changed

    I have two validation lists working great, list 2 dynamically changes depending on the value selected in list 1. However, when you change the value of list 1, the old value for list 2 still shows. I would like list 2 to reset or clear when list 1 is changed. Can this be done?

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top