validation list filtering

  1. K

    how to generate a list of names based on two drop down box selections

    I'm really new to <acronym title="visual basic for applications">VBA</acronym> and Excel, I know a few bits and I have created validation lists and a macro to rename the sheetname depending on what text is entered into a certain cell etc. I don't really know where to begin with creating a...
  2. N

    Linked Drop Down Lists

    Hello! I am attempting to create multiple drop down lists where the second box is dependent on the values entered into the first. I know this has been done before, but this may be somewhat unique. Essentially, I want users to select a value from the first list (in this case, teacher name) and...
  3. J

    Data Validation Trouble

    I have created a dynamic data validation list in a worksheet, using nested IF statements and named ranges. The list shows up just fine, however, I am not getting an error when I enter invalid data. I've checked to make sure the error alert is enabled and recreated the data validation a few times...
  4. S

    [ask] auto validation match finder

    i have a very large database of people's name and i have made my own expendable validation without a macro; but i want to make a macro that could pop-up my user forms (this user form is used to show any suggestions when i start typing; i.e. when i type "A" then comes a list of suggestions such...
  5. R

    Progressive filtering of based on typed values in a drop down list in microsoft excel

    Hello all, I have been racking my brain with this problem for the last few days and alas I have been left confounded with this problem and have no solution. I want to create essentially a recipe spreadsheet by where users are limited in their choices that they put in the ingredients box for...

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