validation

Hi I've searched and found several posts with users having the same issue, and I've checked my formula returns the correct range, but setting up a validation with the following formula allows free text, even though the option to stop if invalid entries made is ticked. To replicate this issue...

Hi all, hope you can help I have created a named table called Customer_List I select List in data validation But when I type =Customer_List into the source box I get the error “The formula you typed contains an error” But the named table has dotted lines around it so it looks like its selected...

I have the following code with which I want to loop through all the data validation options available in the drop down list and copy/paste that output of the data validation option into MS Word. The code "works"... However, when it pastes the report into MS Word, it pastes the last list option...

Hi! I encountered a strange bug. I tried to create drop down list from a set of time series (00:01, 00:02, 00:03, 00:04, 00:05, 00:06, etc.) which is working fine until I type each time value in the cells manually. BUT when I try to drag down to fill in as a series, the data validation does not...

Hey guys , I need help with data validation. I want to allow user to type data in V11 and W11 only if O11 and P11 has data in it So if cell O11 and P11 does not have any data in it then a user cannot enter any data in V11 and W11 I will apply data validation to V11:W31. Data in O11 is...

I make quite a few spreadsheets, intended to be filled out by others. To make them user-friendly (or idiot- proof, as you like…), I like to use data validation for input information, error messages and data limitations. Upon selecting a cell, users are presented with information the content...

Hello all, So I'm trying to do something a little bit complex but am not sure how to tackle it as I'm very new to VBA coding syntax (but intermediately experienced in other programming languages) Basically, I am trying to parse through this text: <Start> <Step> <Description>...

I'm creating a Level of Effort Calculator. I already have some complex VBA macros that help add or delete specific data in the various tables across the worksheets in my workbook, so if VBA is required, that's no big deal. The summary of it all is that in table1, I have a dynamic Data...

Hi All I am new to date validation. Please help me in completing one important excel sheet for my team. I have few dates (total around 300) in column A. I want user to enter date in column B that should not be less than first day of corresponding date month in column A. Example: A4 is...

Get file below is link https://1drv.ms/u/s!AnJwxxiz0Ezpg8YaJybiTFXDUaN6tQ I have sheet call BYE WEEKS I have data validation with no repeat name after you pick team will not be there on rest data validation list. when you pick a team list start at end of list how i fix this that drop list...

In another thread, it was suggested to me to give Data Validation a try as a way of reducing the need to do such extensive data checking in the UDF. So I did a little studying. It looks like it will make my life easier, but, as if often the case with Microsoft products, it comes with some...

I have a column in an excel sheet that users input data I want to make it so they can't miss something important. Using data validation custom formula works great to ensure the user only inputs ##-##-##[A-Z]### however I want to be able to allow them to add multiple entries into a cell with only...

Sorry - probably not the best terminology in the title, but I haven't had my first coffee yet! I just wondered how those of you who work with spreadsheets that are edited by multiple users go on. I am our office's unofficial Excel expert (even though I am VERY far from expert). And I make the...

I've done this easily with two or so levels using the common indirect method, but I'm struggling to apply that knowledge to a greater challenge. Here's what I have: I have a table set up with the columns Room, Option, Style, and Color. I have another sheet where our customer will make...

Hi, I have a workbook 'workbook A' which contains the worksheet 'Datasheet'. Datasheet contains all data validation drop-down lists in this workbook. I would like to replace 'Datasheet' with a sheet from another workbook - 'workbook B' - also named 'Datasheet'. Is it possible to do this...

How do I have Data Validation that can only contain numbers (no text, punctuation etc). I have tried ISNUMBER, however, the field can contain two separate numbers i.e. 33 34 can be a valid entry, but 33, 34 or 34 & 35 should not be accepted

Hi I've written a macro which copies data from one sheet to another, then adds data validation in the last column. However, I keep on getting a debug error when the code gets to the data validation part of the macro. It says "Application-defined or object-defined error." It comes up after...

Is it possible to have a Data Validation for either "NA" or a number (decimal) between 0 and 100 please? (want to avoid a list due to there being several decimal answers)

Hi All, Any help would be appreciated as this is driving me up the wall. I have three cells E17, F17, G17 that use a conditional format to display a tick/cross. F17 is a dummy cell that uses an If/Or statement to display "0" based on the contents of E17 and G17 I want to use a data...

I am having an issue with a lot of hands in the pot on the workbook I am working with. One area is the phone number area. Everyone puts it in different and I need it to show up in one format even if it is copied and pasted over with the 123 pasted option. When pasting with that option it takes...