validation

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...

Good afternoon all, I am looking to to list data validation over different columns but have it so that the selection in the first column will only show a certain selection in the second. So column A will show a certain supplier then column B will only show what that supplier provides, Column C...

Hello I have non contiguous range ($U$2:$AS$1000 and $AW$2:$BF$1000) I need a data validation to alert users when the same date is entered in both range combine more than 12 time. Thanks

Hi, I'm trying to add color validation to comboboxes on a userform - but seem to be having issue with the syntax - I've done this before using defined drop down values and not had any issues.. I'm not sure how to amend this code to validate input based on using the scripting dictionary?.. can...

Hi there all, i want to set a data validation rule so that only the following number sequence can be entered to a cell: 000000-00 the hyphen is a must, if i didnt need the hyphen I would be fine setting this up. Any ideas? I use the data validation from the ribbon, and need a custom formula

Is it possible to have data validation and a formula all in one cell? Current situation is =IF($B4="Testing","NA",""), but I also need this same cell to have a drop down in it if its blank.

Hello friends, Hope all is well! thanks to you, I succeeded in hiding the ribbon by using the below line. problem now: validation dropdown menu is not active. if I remove the below line the validation works. please help me remove the ribbon and allow the validation's dropdown menus to work...

is there anyway to have a selection list to choose from instead of writing a comment in the comment box? Here is what I would like to do: If any cell in range H7:H37 , J7:J37, L7:L37 (which are populated by a validation list) is less than 5, then a comment box would pop up offering the...

Hi, Can someone please tell me where I am going wrong here? =AND(LEN(A62)=5,ISTEXT(LEFT(A62,3),ISNUMBER(RIGHT(A62,2)))) Thanks!

Can someone explain why adding hyperlinks before adding validation switches from "," to ";" which is default xlListSeparator? Sub test2() a = Join(Application.Transpose(Selection.Columns(1).Value2), "; ") Selection.ClearHyperlinks Selection.Validation.Delete...

Hello all, Is there a way to return unique values only in a data validation list that is frequently being refreshed? Thanks, Trent

Good day, I create a new module for barcodes scanning purpose. Which the barcodes contains specific word and number to identify each items. Also iI had made formula to detect if same item are scan repeatedly and thus data validation will stop the process of scanning. Now i need to put model in...

Is there a way to do data validation to prevent text entry in a cell without using a macro? We also want to be able to copy data into the spreadsheet with the data validation.

I am trying to set the character limit of my cells to 28 and force the characters to be uppercase using Data Validation so the user receives an error if either condition is not met. I have the uppercase portion working fine, but cannot seem to get the length to function correctly. It seems Excel...

I have been trying to research this but can not get anything to work. I am trying to use a data validation list that shows 1 thing but puts another thing in the cell. For instance I would like to see A in the validation list but when I click A the cell value shows 111. Hope this makes sense...

Hello, I have the following spreadsheet. I would like to add data validation to Row 4 to look at Cells 46 and 49. So basically what I would like to do is not allow the operator to fill out the next column of data IF cell 46 says Failed and cell 49 does not have text in it. If cell 46 says...

Hello, I can't believe nobody has asked this question before but I've looked through past posts on this topic and have scoured Google and cannot find an answer. I have data validation on a cell that uses a range on another sheet to populate the drop-down list. All I want to do is make it...

Hi All, I am using SUMIFS if the results in my list are met. I have either Y or N. I am wondering if I can add another drop down that would be ALL. I am looking to be able to filter our all the Y, N, or ALL if I want to sum all of the results. My formula is as follows; the bold is the part...

Good morning, I have a workbook where I’m using indirect validation to breakdown compliance procedures for processes we’re required to perform. I’m breaking down our source materials from Sections, to Paragraphs, and finally subparagraphs. After I finished with the base data validation, I may...

I am having problems adding data validation to an existing transaction table (some 200+ rows), as the custom formula validation does not get replicated when a new line is added. In this case it is to give a warning if the transaction date is not +/-30 days from the current date...