validation

I have a worksheet that has thousands of cells containing data validation. I recently noticed that when I copy an entire row from the original worksheet to another worksheet (within the same workbook), the data validation in some of the cells change unexpectedly in the destination. The data...

The answer to this may be just a flat no!, but I am looking for a way to allow a data validation to be imported to another sheet and be edited by that sheet. Here is what I am looking at: Cell A is a reps name, Cell B is a customers name, Cell C is the result. Each rep has their own sheet...

https://chandoo.org/forum/threads/data-validation-for-2-columns.42439/HI, Looking for solution to one problem. Problem is -we have number of countries in different regions like Europe,Africa etc. I have data validation in col A and Col B...when I choose any region in col A it is also showing...

Hi everyone. I have a worksheet that includes roughly 20/25 different columns. Five of those columns contain Data Validation drop-downs to different data lists. I'm having an issue with users of this worksheet copy/pasting incorrect data over the top of the columns with Data Validation vs...

I have data validation set up allowing a range of cells to only accept whole numbers between 0 and 100. I currently have a bland error message that pops up if the user enters data that doesn't fit the criteria. However, I want to add a picture instead of some text. Is that possible at all...

Hi, Please refer to the image in the link below. I’m trying to create a data validation that lets a user choose Product and Colour of a car from the Manufacturer. Is there way to put some function in data validation list option so that it looks for Audi on the worksheet and takes the...

Hi, I have a named range [Range_Date] filled with dates Jan 2019 - Dec 2020, incrementing monthly. On another sheet I have two cells with data validation for list with values [Range_Date], where one is the start date and other end date. Is there a way to set data validation to ensure end date...

Hi Folks, I have a data set which has role titles in the first column and country names as headers. Each column contains a role cost for each country. I am trying to create a dynamic Data Validation list where it will show only roles where cost is greater than zero for the country selected...

I'm working with a workbook that allows users to enter a Start Date, and End Date in two different cells. My objective is to display a list with Data Validation to select the date range without having to key it in manually. The problem I'm having is because the workbook is connected to an ODC...

Hello, I use a lot of lists in Data Validation. It gets tedious to bring up the list and scroll through until I find the one I want. Is there a way to use type ahead to select the choice without displaying the whole list? Thanks, George Teachman

Hello, When using a date picker or textbox in a user form can i use data validation to message users to select a new date if a Saturday, Sunday or a list of dates on the worksheet. I can do this on a cell using the following formula data validation Formula...

How to drop down list (data validation ) automatically when cell is selected ? How to make the list ( data validation ) searchable ?

I have a workbook that contains three validation cells, 'Brand'; which has two values, 'Customer' and 'Product', both which have multiple values. Two seperate datasheets (tabs) for each 'Brand' contain the 'lookup' data, both containing columns for 'Customer', 'Product' and 'Discount' Im trying...

<tbody> THINGS Red Blue Yellow </tbody> I have the above table that I am using as a Data Validation List. The Data in the Table is dynamic & does not always have the same # of items in it. For the purpose of Data Validation, I have given Table1[THINGS] the Named Range of...

Is it possible to have the data validation in a cell NOT permit any entry at all unless there is a valid date in another cell? I tried this... =if(H9,0,0) ...but it still allows data to be entered in the cell I am trying to validate. Cheers!

Hi all, I am trying to create a report for our marketing department to fill in figures on an ad-hoc basis. I have this idea in my head which I hope you can help with. Basically, I would like to know how to do the following: Based on what the user selects in the blue cells (using Data...

Hello, I did use formula right in the cell before. But If I remove other info the formula will be removed, so I decided to use data validation lists instead. I'm having =INDEX(OFFSET(BusinessNameStart;MATCH(D3;BusinessNameList;0)-1;2;COUNTIF(BusinessNameList;D3);1);1) So, this one will find...

In cell "B1" I have a data validation (LIST). The validation list consists of the data "A,B,C,D,E,F,G" (within the drop-down). I want cell D1 to auto-insert data from the drop-down list in "B1" For instance... If I select "B1" with the data "A", I would like to have "D1" fill with the word...

Hi, I have a table of legal entities (L.E) and divisions in those entities, which I do not want to transform. I am aiming to produce a drop-down of relevant divisions for selection using data validation in another cell. Here is my dynamic range...

Hi All I am using data validation for a list in column C. I also need to prevent a single space from being entered in column C, so I would like to use code in column C3:C5000 with a message "No space allowed" Thank you in advance!