validation list

  1. R

    How do we using dynamic list based on condition criteria from cell value?

    We using dropdown dynamic list from master using OFFSET function for except blank data's, Here, we would like to next two columns lists should allow/block based on the previous column list value, Kindly help us anyone, how to do this functions in excel? Eg: In above example, First List...
  2. M

    Shrinking Data Validation Drop List with a column in between

    Hello All, This is my first post, I've looked though the forums and I've found some items that come close but not exactly what I'm looking for. I'm working on shrinking drop down list with data validation. I'm able to get it working while using 1 column and adjacent columns, the issue comes...
  3. L

    create dynamic dropdown based on UNIQUE values from a column within a table

    Hello expert Excel users! Below i will describe what is the purpose of my first forum post, so bear with me. So i have multiple tabs defined as tables in a big excel file. Each table has one or more columns but then, some of the tables do have common fields among them. What i want to do is...
  4. Q

    Hyperlink function from drop down menu data validation list throughout entire workbook

    Hello need a little help "YouTube": Hyperlink function from drop down menu data validation list throughout entire workbook "YouTube": The validation link hyperlink listed above works great but it links to other sheets and I need it to link on...
  5. 9

    Validation Tables - how to get one to feed from another

    I currently have one validation list. Lets say it is different types of pets (dog, cat, bird, fish, etc) and that is in column A on Sheet 1. This is my current validation list and there are 15 different options to select from currently. What I need to happen is if I select dog in column A and...
  6. I

    Selection of dropdown list value with a checkbox

    I need help trying to implement a check box to automatically select a dropdown list value when checked, but when it is unchecked i would like to be able to select the value from the dropdown list. So, I have: <tbody> A B C left right left right left right upper ? ? ? ? ? ? lower ...
  7. A

    Help Please: Indirect named range in chart data, pulling from validation list.

    Hello all - I recently posted something similar here, and got some great help that got me 70% of the way, but I'm still stuck. Was hoping someone could pick up the thread and show me the error of my ways. Thanks! Final result desired: I have a chart on Sheet3, and wish to update that chart...
  8. G

    Problems converting array formula to dependant drop down list

    Hi All, I've been trying to find an array formula for a dependant drop down list I saw a few years ago. Basically, I have three Source columns (Category, SubCategory, Details) that I need to work with. Constraints: Must not use VBA, Helper Columns, Macros Source is not defined as a Table...
  9. R

    Automatic Sheet Rename When Validation List Changes

    Hello, Just finished my first 3 day VBA class last week. I'm intermediate-advanced in Excel, but have been struggling with VBA. I've been search throughout the web for some code that will dynamically rename the current worksheet when I change the entry in a certain validation list. I found...
  10. D

    Require Data Validation List to only allow Exact Match

    Hi I'm trying to get the data validation to only allow exact entries in cells based on a list. I'd previously achieved this by entering a delimited list but this doesn't seem to work so well with Office 365 on Mac. I have student grades and codes as a range. These include: A B C D E NS Ung NR...
  11. C

    VBA worksheet event to delete dependent validation list

    Hi Excel jedis, how can I change the below code to only clear a specific cell instead of column . (lets say cell B2 and C2 and clearing C2 when B2 i changed.. ) As usual, thanks inadvance Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Column = 2 Then If...
  12. V

    Validation list with array formula (index/ match)?

    Hi All, I am trying to achieve the following, using the table below as expample: Set up in D1 a validation list (dropdown) that pulls the right values from column B, based on the filter on A (from user choice in C1). E.g. if user inputs "Joe" in C1, then the validation list in D1 should have...
  13. S

    Disappearing Validation List Choices

    Dear Excel community, I created a model that used several Validation Lists that had drop down choices. I saved this file on a external hard drive and was recently looking at the file. All of the Validation List cells no longer show the drop down arrows to make cell selections. All of the...
  14. L

    creating a product renewal validation report

    I have to deal with hundreds on line item prodcts to ensure to provide clear response if a product is beling ordered or still available for ordering and what qty is available to be ordered, in case not all product qt where bought for certain period I hope below is clear on what I am looking...
  15. S

    Help with validation list using vlookup or index match

    I have sheet with two columns, say A and B. I would like to enter text into A and have B show a validation list of values based on what has been entered into A. In another sheet there is a simple list of the values A could have and the associated values B should have. eg: Sheet 1 A...
  16. E

    How to run code automatically every time a drop-down validation menu changes the case

    Given two workbooks named as follows: "W01_Clients.xls" "W02_Macros.xls" I wrote a piece of code in a module of the workbook "W02_Macros" to make a sheet (named "S02_AuxBackOffice") which it is placed in the workbook "W01_Clients.xls" to be visible or invisible when runing the code from the...
  17. L

    Vlookup and data validation in same clumns

    Hello I'm working on enhancing my xls where currently, I use a Vlookup to show SurName (Col J), FirstName (Col K), Rate (Col M) and Hours (Col N) based on knowing a unique ID. So formula used in Col A is =IFERROR(VLOOKUP($L1,Personnel,2,FALSE),"") where L1= a unique ID, Personnel = table range...
  18. F

    Validation List - Multiple IFs - Formula to big

    I´m working on a formula for a validation list. What I´m doing is: User chooses the month: May ( for example - the drop down has all 12 months ) Once the month is choosen - there is a second drop down list with the days of that specific month. I´ve named range all the months My problem: The...
  19. C

    Username entered in a cell when validation list is used

    Hi guys, Is there a way to have a formula or a VBA code associated to the choice of any value in a Validation list. For example is there a way to have lets say in A1 a validation list and to have B2 returning the username of the person of who will select a value in A1? As ususal thanks in...
  20. F

    validation list of two valies

    Dear All following is my data <colgroup><col><col><col></colgroup><tbody> CODE MATERIAL 1 MATERIAL 2 111 150 X 215 400X00 123 150 X 215 124 500 C 1 112 150 X 215 24.5 </tbody> MY QUERY IS When I enter Code in one cell., then the other cell validation list only contain material...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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