data validation

Hi, I can not for the life of me work out why this data validation code is not working?!? =OR(F8="Enter YE Date",F8=EOMONTH(F8,0)) The second part works, allowing only a month end date to be entered, but it will not let you enter text "Enter YE Date". I'm setting this under Custom/Formula...

Hello, I've got a macro working that creates a Data Validation drop-down list. I duplicated it to repeat the process for a list of three dates. However, no matter what I do, they never make it into the Data Validation Source field in the format they show in the VBE. VBE Shows: DV Source...

Hello, I'm trying to insert a return value based on the value from a drop-down list using WorksheetFunction.Xlookup... within an existing Worksheet Change event. Scenario: I select a Student Name from a drop-down list. This triggers a Worksheet Change event to create the drop-down list...

Hi there, There are a lot of very clever data validation techniques, however, I missed the following one: Problem statement: you want to restrict user input to a small number of different dynamic arrays, or not at all (i.e., free input by keyboard). The dynamic arrays will be defined as named...

I have a fairly sizeable workbook with a lot of named ranges, many of which are probably redundant which I'd like to delete. It's fairly routine to establish if a named range is used in a Formula or in any part of the VBA code within the workbook, but I can't think of a way to work out if a...

I have a excel file that I use to give as a test for the students. If has 2 Sheets. In Sheet 1 There is a MCQ, with 4 options, The Column A has the questions, followed by Column B-E with the 4 options and the Column F Has the right answer to that question and Column G uses the cell for the...

Hi beautiful people, I have a problem with a file, because I can't figure out how to make a data validation that does what I need. So, I want the data validation in cell A1 I have cell B1, where I can have it empty, or with a value(number) Data validation that I need: If cell B1 is empty...

I'm trying to create data validation rule that will change cell color depenidng on percentage of the value from the cell above e.g. G7/G6>0.8 change cell color to green, G7/G6>0.5 red etc. How do I create a formule in data validation that will apply this rule to all selected cells without...

Hello to everybody I have found the below very useful code from Contextures Excel Resources to Help You Succeed Option Explicit ' Developed by Contextures Inc. ' www.contextures.com Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String Dim newVal As...

Hi all, I have a series of drop-down lists created via data validation which pull from a separate sheet of dynamic lists that are driven by a series of rules. In other words, my sheet consists of a series of conditional drop-down lists, each one affecting the available options in the lists that...

Hi All, I struggled a bit with the title - so I'll try to explain more clearly. I have created a Table in Excel, which I intend to share with a selection of users to populate. This will result in a indeterminate number of rows being populated. Each column in my Table (10 columns in total)...

I have several ranges of cells on multiple sheets that I have manually applied both Conditional Formatting (CF) & Data Validation (DV). However, only some ranges actually work. I've also tried this by recording a macro for the CF and then using the macro to save time and avoid any errors. When I...

I have a spreadsheet that we are trying to build dependent dropdowns for several values. Column A is the 34 Organizations. Each of those 34 Organizations has a unique list of Owners, Departments, Areas, and Accounts. I have limited the the sample file to 10 organizations. The desire is to be...

Is there a way to look up a name OR number in a data validation list but only let the user select the number and then have the associated number populate in the adjacent cell? My goal is for users in a file to be able to see the project numbers and/or names (some users search by names and some...

Hi, i am working on a new employee performance evaluation form. Managers will fill the form for each of their employees semi-annually (attached). Each employee should have a minimum of 5 objectives and a maximum of 10 per each 6-month period. In the old evaluation form, each objective had a...

I am working on a shared spreadsheet for tracking and I need users to ONLY be able to enter a value that is LLNNNNN-NN (letters and numbers) and in another column (different data) LNNNNNNN-NN. Both are combos of letters and numbers but I need users to only be able to enter it in these ways. For...

Hello Everyone, I am working on a project using MS Excel 2021 data is organised as tables and stuck at these two problems as follow: 1. I need a setup the data validation will check the entered quantity in the "Qty" column of the "Invoice Detail" sheet against both the...

Hi guys, I am working on a project for my work which is a form that users can use to help them make decisions etc. I have this code that provides the ability to make multiple selections from a data validation list, so instead of the default excel position of being able to select one option...

A user enters: 1) The Start date of the month in Cell B1 2) The joining date (in case of a new employee) in Cell B2 3) Number of days worked in the current month in Cell B3 which has a custom data validation check as follows...

Anything I try gives me the error "the list source must be a delimited list, or reference to single row or column" What I have now is something like =IFERROR(CHOOSE(IF($AC1="Update Location",1,IF($AC1="Update Source",2)),SUMMARY!$B$17:$B$226,Master!$X$2:$X$1048576),"") where if Update...