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?

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