data validation list

  1. D

    Variable Data Validation List Based on Cell Value

    Data Set:Sheet1 (Table 'Alpha' on Sheet1!A1:B200) -ColumnA: Employee_Name (sorted A-Z) -ColumnB: Qualification_Code (01A, 01B, ..., 01Z) (Each employee has a single Code, but multiple employees have the same Code) Sheet2 (Sheet2!A1:C100) -ColumnA: Position_Title -ColumnB: Position_Code (01A...
  2. B

    Cascading Data Validation List based on Multiple Conditions

    I have a table with the following columns: Account, Sub, and Split. I'm trying to create cascading data validation lists where you first select the Account, then the Sub, and finally the Split. So in the table below if I chose Account = 501650, then Sub = 00-240, the third Split list should...
  3. I

    Always Show drop down list Of Data Validation List

    Hey everyone! Is there a way to always show drop the down list Of data validation list?
  4. U

    Advanced dropdown - multiple words

    I'm having difficulty in creating a drop down menu thats dependant on the 1st drop down. For example, I have a list of product lines, Regulatory Compliance, Anti-Fraud, Financial Custom, Financial Control. I have a separate list of the items that relate to Regulatory Compliance, Anti-Fraud...
  5. S

    Formulas in data validation range causing blanks

    I have a workbook where users can input job titles in two different ranges (A2:A6 & A8:A12). Only one range would be filled at a time, but I want to use one data validation list for both ranges without blanks showing up within the list. The problem is if I use formulas to generate the range for...
  6. A

    Data Valadate and vlookup/offset/Index help

    What I have: Sheet 1 has a list of tank_id's (no duplicates) called "Details" (Columns are Tank_id, Tank_Name, Nation, Turret, TArmor_front, TArmor_rear, TView_range..). Sheet 2 has a list of Turrets and the specifications called "Turrets". (Columns are: Tank_id, Turret_id, Turret_Name...
  7. V

    data_validation_list reset on excel start up

    Hello, I am looking for a way to reset all my dropdown lists in a workbook to their top choice. Right now I found the following code, but it is for a certain sheet only, whereas I want all sheets with a dropdown to do this. plus I want this to only work when the sheet is opened automatically...
  8. M

    Consolidate function for result of VLOOKUP

    I am using EXCEL 2013 and am trying to find out if there is a way to auto-update the consolidate function. I am using a vlookup based on a data validation and would like to consolidate the result automatically when the value in the validation cell changes. I can't post the worksheet here for...
  9. J

    Data validation drop-down list

    I created a drop-down list with different fruit names and I want the user to be able to type in the first couple letters of the fruit name and have it auto-populate. For example, if the user types in "ap", the word apple would automatically appear. Is there a setting within the data validation...
  10. L

    Data validation for drop down

    I have a excel sheet and i have created a data validation function. Its a conditional dropdown but I can not input my equation in data validation field. Its says too many arguments. My equation is =IF(A4="Capital",'New List'!$C$2:$C$42,IF(A4="Pier Caps",'New...
  11. T

    Trying to use Indirect and offset in a data validation

    Hi, When I use inside a data validation (list) the expression: Offset('Sheet1'!$E$1,0,0,COUNTA('Sheet1'!E:E),1) I get the correct list. I also have that expression as a text in the cell A1. When I write the expression in the data validation (list) =INDIRECT(A1) I get an error and no list is...
  12. T

    Data Validation and Index Match

    Hello Everyone, I am trying to create a data entry worksheet that includes a data validation list based on Index/Match values from our Purchase Order Table. I have used data validation to create a drop down list for the PO, and I am trying to create a second drop down list based on matching...
  13. T

    Filter With Data Valadation

    Hi All, Losing my marbles with this now.....:(:confused:. I have been trying to work out a way to filter on Data Validation. I:E On one sheet I have all my data and the separated by 5 different categories. <tbody> Cat sub Cat Price Pack Size Colour A 1 5 12 red B 2 10 12 blue C 3 7 45...
  14. M

    Using Named Ranges in Worksheet_Change

    Hi all, This is my first time posting a thread but a few years following yours. I have the following code which I can't make it work. It works when its refer to a single cell but it does't works when I use a named range. I have a named range "TGCEne" in the active worksheets with data...
  15. U

    Apply Filter on Data Validation List based on row value

    HI I have two Columns <tbody> Data Products ON Product 1 OFF Product 2 ON Product 3 </tbody> I want to populate a data Validation list which has the values where Data=ON Please help.
  16. W

    Conditional Data Validation - Lists

    Hello - I am looking for a way for my drop-down list to only display certain options based on a drop-down of another area. Essentially, I am looking at a Function vs. Subfunction. I want my data to be tied firstly to the function drop-down. Let's take for example: Function (and sub-functions...
  17. M

    Lookup all possible surnames based on first name in another cell - for DV list

    I have a table containing education assessment data and need to use the data to analyse a child's data on another worksheet. So far I have set up 3 drop down boxes that contain 'First Name', 'Surname', 'Class'. I have set up these to look at the fields in the table but I would like it so that...
  18. S

    VBA Code For Changing Tab Color Based On Cell Values In Drop Down List

    I am trying to change the color of a tab based on the cell value in B5. B5 is a drop down list using data validation that contains four entries: "Flow Rack" , "Workstation" , "Machine Guarding" , and "Other (custom)". A tab is named after each one of these as well. If someone selects...
  19. K

    AutoComplete From a List

    I have a list on a separate sheet that I am wanting one particular cell to autocomplete from. I have searched for quite some time on a resolution to the issue. I have even placed the list above the cells I am working with, and then hiding them, but after I am finished with my current task I...
  20. L

    Data validation list and Vlookup in VBA, to input, on cell change, if/vlookup formula referencing cell that was changed

    Dear Excel Guru’s I’m struggling with one of my last tryouts in Excel Macros. I would like to have in my sheet combination of Data validation list & Vlookup. But I want to have it in Macro, so user won’t be able to see formulas, delete, edit etc.. I succeed with stand-alone Macro (what was...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top