validations

I have created a 23 column spreadsheet with data validation cells using drop down lists and a few columns that do the standard date formatting (4/18/19 displays as Thursday, April 18, 2019) Converting it to a table is not desirable and I would love to have a user form that "pulls" the...

I understand that I can loop thru .xlCellTypeAllValidation using a For Each loop; however, I'm looking to do things a bit more efficiently, specifically is there a way to group all similar validations into a single range using either .Areas or .xlCellTypeSameValidation...

Hi, I need to apply two data validations in a single cell. One is the name and other is a text 1) =validation_customers (This one is a named range) 2) ALL (This one is a simple Text) I would like to know how to apply these two in a single cell. Any help would be appreciated. Regards, Humayun

If I have in one drop down list(data validations) one thing how to connect with 2 or 3 more list. I know with Indirect functions but with that does not work(only works with one no more) Ty

Hello everyone. I have a question regarding validations: How do I get my drop down to start at the top of the list when I engage the drop-down button? Currently when I click on it, the list pops up but it's at the end of the list and i have to scroll up each time? Any help is greatly...

Hello, I am trying to preform a duplicate row check on a data set spanning over 6 columns and approx. 250,000 rows of data. What I am trying to find is the more efficient way to highlight any duplicate rows. The code I have at the moment currently take around 45 minutes plus and I can’t help...

Hi. i've a excel sheet where i need to perform validations. ex: i've a column by name Item Number. validations to be performed on column is: -> if user enters alphabets, it should display message Item Number should be numeric only. -> it should not be blank -> user should enter value only...