validation

I have some cells with data validation turned on with list of values for the allow list. I've disabled the input message and error alert because the list contains the most common entries for these cells so other values are OK. However, when I put in other values, a little green triangle shows up...

I have a worksheet named 'RAG' that creates individual sheets for each student. currently I have the code below that prints each validation. However, I'm looking at a way to have option to save it as one PDF document. I will want to be able to choose file path and name at point of save. Any...

allow to enter value in cell, only if 1. data contain 1 time "x" value between two numeric value . & both numeric values should not be more than 99, e.g 34x45.5, (allow)...... 21x56.44 (allow) 23c45.5, (not allow). 23 x 45.5 (any space not allow) 101x22 (numeric more than 99 not allow)

Hello, I'm trying to add Data Validation to 50 cells in a column that will only accept: Alphanumeric Hyphens (dashes) No restrictions for length. I did find some examples, but they are all for a single cell. If I try to change it to a range it breaks and won't let me save. I tried this...

I am trying to make a data validation list on Sheet1 that references all non-blank items in column A on Sheet2. I have accomplished this pretty easily (although, is there a way to exclude the header without just selecting a long range like "A2:A5000"?). Now, I want to trim that list to only...

I have a excel sheet called data with 3 columns: id, name I have another sheet called list with 3 columns: id, name I have made a data validation on column name in data sheet with this > formula: =list!A$2:$A$37000 its working fine and gives me a drop down list from my names in list and...

Hello, the good example of drop down list is here: Prevent duplicates in cells where there is a dropdown list It is not working when typing allowed value, for example "peaches" and pressing enter on the keyboard. The value "peaches" is accepted when it is choose directly from the list or...

Hello I needed help with identifying all required data that has been left blank. I have multiple workbooks and within each workbook there are multiple worksheets, all have employee related rows of data. I wanted a macro/vba script to be able to automatically go through each worksheets within...

Hi Guys, Columns B, C, D, and E contain a list look-up (Yes or No) Earlier today, you guys helped me that if column B and/ or E has "Yes", to return certain text (Thank you!) I placed the updated functionality in column F. Then I wanted the user to identify the scope of work based on the...

Hi All, A user on this site kindly provided me with the below code. The code done exactly what I wanted at the time: "I have a dropdown list on column AY with 'In-Scope' & 'Removed' as the options. If a user selects 'Removed' I want to force them to enter free text in column AZ to explain why...

I have attempted to attach the mini sheet below with a Data Input table in which I have created. All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc. The cells in the ticks column is a manual entry...

Hi everyone, I apologise for being noob, I'm new to posting on this forum (even though I've been a member for ages!) I'm having difficulty with validation (not my own btw... Excel's) validation works fine when you enter text into a cell, but it doesn't work when you are working with a user...

Hi all, i feel like i've watched a million youtube videos and read a million articles and they all seem sooo similar to what i'm trying to accomplish, but i just can't quite get there... Here's the situation; Excel 2016, will be a shared workbook so no tables allowed, workbooks will likely have...

Hi, Could you guys help me with what type of formula would I use to check address formatting and return a true or false? An example case would be the format of address must be (number, street names, location, state zip) with the commas and spaces. ID FULL ADDRESS VALIDATION 611762 101...

Hi community, I have big table of monthly spending, i wanna know how can i show results based on Data Validation list choice, 1-List shows Models ( E:E ) 2-List shows Department ( B:B ) 3-List shows Month I need formula to return matching all 3 list, can anybody help me please?

I have a table in which currency in A and values in B <tbody> CAD 2 USD 13 AUD 15 CAD 5 CAD 11 </tbody> I enter text CAD in C1 and make data validation list in D1. Based on text in C1 data validation only shows the value against CAD. like image attached.

Hello everyone! In a sheet i have the following: A2=Joe; A2= Jack; A4= John and for each name there is a recommended Name list in B2:B4 (Fruitlist;Vegetableslist;Dairylist) A2:A4 is defined as Names G2:G5 is defined Fruitslist L2:L4 is defined Vegetableslist Q2:Q4 is defined Dairylist In B7...

Hi all I have a data validation box in cell b2 with the following options, Q4-19, Q1-20, Q2-20. Columns a:c are locked data for Q4-19 starts in column d to p data for Q1-20 starts in column q to ac data for Q2-20 starts in column ad to ap Based on the data validation selection I want the...

I have a data validation with a nested if statement. =IF(R8="D18",D18_OP,IF(R8="D24",D24_OP,IF($R$8="D34",D34_OP))) It works fine as long as I don't have D18 in R8. D18_OP named range = "Not Applicable". When D18 appears in R8 the drop down will not load with "Not Applicable" nor can I select...

Hi, I have an excel sheet to track project status. I've created a Macro that moves the a row from Sheet1 to Sheet2 when 'Complete' is selected from data validation drop down. The problem is, when the row is moved to sheet 2, the now empty row loses all it's data validation. Is there any way...