data validation

Hi there, Due to other formula's relating to the cell containing this data validation, I need to amend it slightly. It currently looks like this; =OR(AND(ISNUMBER(B13),LEN(B13)=3),AND(ISNUMBER(LEFT(B13,3)+0),ISNUMBER(RIGHT(B13,3)+0),ISNUMBER(SEARCH("/",B13)),LEN(B13)=7)) I would like to...

Hello Is it possible to have a cell populate an alpha numeric sequence based on the selection from a data validation list? For example I was hoping to be able achieve - if someone selects “Design” from the drop down, this would cause the next cell to populate “DR134” and so on sequentially...

Hi, I'm trying to add a date validation for a cell (or column of cells) containing a custom date format of dd-mm-yy I need to keep the data in format of dd-mm-yy because it's copied and used in an SQL Insert statement which needs the date in that format. I'm trying to add a validation so that...

Hi, I'm trying to concatenate 2 custom formulas to use in data validation. I need to restrict: 1) text length (numbers or alpha) greater than 20 characters 2) The use of ' (apostrophe) and * (Asterix) I have: =IF(OR(LEN(A1)>18),FIND("*",A1)) but this wont allow any data to be typed in at all...

Hi all, I'm trying to use worksheet triggers to run a macro but it only works one time and then never again. Example: If write a worksheet trigger to hide rows if a cell displays 'Yes' (list data validation), it will work the first time after the workbook was open. After it has worked that one...

I have been playing around with Data validation trying to get something that will allow a user only to enter the format below when typing in their number IT has to have PR to start and 5-7 numbers attached Example PR12345 or PR1234567 will work however; PR12345678 will not work DD123456 Will...

Hi Guys, I have a couple of sheets that are accessed my one other person. I have dashboards with pivot tables that are all based around grouped dates. My colleague is in the habit of not filling the info out correctly and has been know to leave a date blank and refresh the workbook, hence...

I'm trying to get a dependent data validation list set up. I know I'm supposed to use the indirect function along with substitute (because the first list has spaces in the options). I think it has to do with my named ranges. I've added an image with a snapshot of my named ranges. I'm...

I have different accounts listed horizontally as in the picture. I'd like to create a data validation in a new cell that containing all the accounts I have i.e. "My credit card" and "Paypal". I've been working at this problem for hours. INDEX and MATCH don't work in this case. Why real-world...

Hi, can any VBA expert help me with a code just to force mandatory input into a particular range when a specific cell in same row is filled. Traditionally, I have used elsewhere, & tried again here - to use EXCEL's provided Data Validation - Custom Setting - Formula - to achieve this, but in...

I've got three tables TableA: <tbody> List of Tables Other Info TableB Info1 TableC Info2 </tbody> TableB: <tbody> Column A Column B stuff morestuff otherstuff extrastuff </tbody> TableC: <tbody> Column A Column B onestuff redstuff twostuffs bluestuff </tbody> I ultimately...

Hi all, I have a single worksheet with 20+ data validation dropdowns. I want to insert a Command Button that will reset all the dropdown cells to the first option on the dropdown list when I click it. Having never used Macro/VBA before, I’ve tried researching the appropriate code to make this...

Hi Everyone, on my worksheet I have two cells B3 and C3 which have data validation. So what I want to do is when either of the cells change, it will update two pivot table's filters. (Target & Actual) Below is what I got working when looking at only B3 and updating the Region. The values...

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!

Hello, I have a few columns (not adjacent to each other) where I expect users to enter valid e-mail addresses. What I would like to validate is that the entry contains all the valid characters possible, namely digits 0-9, latin letters a-z (not case sensitive) and special characters...

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

I have a worksheet that has thousands of cells containing data validation. I recently noticed that when I copy an entire row from the original worksheet to another worksheet (within the same workbook), the data validation in some of the cells change unexpectedly in the destination. The data...

Good morning! Newbie here, but I've exercised about all the Googling I can do to find the solution and I just have not found one anywhere. Wondering if any expert VBA guys/gals can help a rookie out... Problem: When manually selecting cells that use List-style Data Validation, I can no...

I have a column of cells in which I need users to input their time spent on a project ( time input as [hh]:mm ) the hours are accumulated over a 6 month period so can exceed 24 hours - but I would like the times entered to be restricted to 15 minute intervals (eg. 60:00, 55:15, 43:30, 38:45...

Hi, I am tying to find a way to create a hyperlink that goes to a specific cell in my sheet. I want the hyperlink to be dynamic and change based off a data validation list of values. For example: Cell B2 contains my list of values, so in B3 I would like toinput a formula that says when...