validation

Hello, I am looking for some assistance. I have a table that auto-populates from a second table using equations once the first cell is populated. However people are going in and pasting over the equations and I was hoping to use data validation to prevent this from happening. I cannot protect...

I got a bit bored at work today and decided to took at the standard templates in excel to see if i could pick up any new tips and tricks. I downloaded this one created by Mircosoft but there is something in it that i cannot work how they have done it...

Happy Friday! I'm trying to force users to input a date range in the format of MM/YEAR - MM/YEAR into a specific cell (B1). I tried using Data Validation but I received the "..value doesn't match..", error alert when testing it out. I selected the Custom option and typed MM/YYYY - MM/YYYY in the...

Hi all, I have a data validation list. Lets say F1,F2,F3,F4 located in cell A5 all these have a list of products Is it possible that the list associated with list number (F1 TO F4) populates in column B when I select the data validation number from the list Any help with this would be...

Morning, I have 2 columns as explained below. Column J consists of values like Z159, R235, P004, N/A Column L consists of values like JHMCN129357842S87, N/A The columns have a drop down where the only selectable option is N/A When i use the Data Validation Circle Invalid Data option i see a...

I’m trying to use a msgbox to provide instructions if validation criteria are violated. I’m able to get the validation configured, but I would like a different message box to appear when the entered data is outside the validation criteria. For example, the validation criteria require the...

Hi there My problem 1. Column A captures either "yes" or "No' from a data validation list 2. Column B Captures dates from a data validation list If the response in column A is "No" then I want the date to equal the date in the cell above. If the response is in column A is "Yes" then I want to...

Hi All, I'm looking for a data validation formula that can achieve the following: Only allow the input of a 5 digit number Don't allow the input of the 5 digit numbers in a list (The list is in cells F5020:F5045) Any help is much appreciated Thanks Tom

HI Team, I need some help in data validation. I have years in column "A" like 2010,2011,2012,2013 so on ...and in column "B" I have quarters like Q1,Q2,Q3 so on....so, each year against quarters will be listed and not necessary every time 4 quarters some year should have 1 or 2 quarters as...

Hi All, I created a calculator with data validation and then created a formula to calculate qty of t-shirts by color by size using SUMIFS, but when I change the data in the calculator, the data leaves the previous cells calculation, For example, if I have 5 green t's in small, the result is in...

Hello, Is there a way to avoid losing conditional formatting and data validation when pasting data in the cells? Thank you.

Hi, I am trying to accomplish two goals and would appreciate any advice: Goal 1 When my Google sheet is opened, and every time it is opened, I would like the contents of Cell A2 to be cleared -- so that it has no text in it left over from the last time the sheet was used. I also have several...

Hi All, I have a list on a sheet named "Actions List" and I need to use a data validation list and be able to add the text from cell "E4" on the sheet to each item in the list. Essentially I am trying to use the " & " character to combine the names ... Here's my formula that is not working...

I am trying to write an If statement using Data Validation drop down for a combined bank ledger. I am having trouble getting data to filter properly. I can get it to function with 2 selections but when I added the 3rd i can't figure out the statement order. Any help it appreciated...

Hello, I am trying to create a validation for a specific syntax. Example: BP:402865 The BP: is fixed but the 6-digit number varies. Could you please help with a formula that I can use in the validation? Thank you

Good morning I have a cell which requires a user to put an entry of between 0 and 1 million so I used the validation Allow: Whole Number Data: Between Minimum: 0 Maximum: 1000000 Ignore Blank: Unchecked I have a message which tells the user the acceptable range in case they try to enter a...

I would like my users to be able to copy and paste freely on a ListObject table, but only values (i.e. not messing with formatting/data validation). Is this possible with a worksheet change event ? many thanks Andrew

Hello I have a workbook with a link to and old file, i have tried to break the link, open source, change link, get rid of any conditional formatting, delete irrelevant work sheets, data validation etc, but i still cannot break this link! Does anyone know anything else i can try? Thanks

<colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;"> <tbody> Place Person Maropeng Jetash Maropeng Jetash Maropeng Jetash Zoo Mark...

Hi Team, I have data like this and im using formula =IF(C3<=E3,"","FALSE") to get the result in column D. I want column D5 to display a message stating no data if date in E5 is blank rather than false. Could you help? <colgroup><col><col><col><col><col></colgroup><tbody> Column A Coulmn B...