data validation

  1. D

    Ensure that no blanks are left in Date column

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

    dependent data validation

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

    Create Drop-down List from Multiple Columns

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

    Force mandatory input into particular range when a specific cell in same row is filled

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

    INDIRECT in Data Validation

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

    Insert Command Button to reset multiple Data Validation Dropdowns using VBA

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

    VBA to intersect cell changes (both data validation) and action separate functions

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

    Data Validation - 3 Letters + 2 Numbers

    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!
  9. A

    Data Validation for E-mail Input

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

    Data validation to disallow blank entry when using drop down list

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

    Data Validation Bug

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

    VBA - Unable to delete objects w/ INTERSECT if using Data Validation

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

    Data Validation - 15 Minute Intervals - Time Range

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

    Hyperlink to cell in sheet based off of list of values

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

    Excel VBA User form validation of date to exclude Sat, Sun and Holidays

    Hello, When using a date picker or textbox in a user form can i use data validation to message users to select a new date if a Saturday, Sunday or a list of dates on the worksheet. I can do this on a cell using the following formula data validation Formula...
  16. R

    Data Validation Query

    Hi All, Could you kindly help me how to validate below data set in excel ? <tbody> ID Group_Name 112 Group 1 113 Group 2 114 Group 3 115 Group 2 </tbody> I would like to write a macro to validate that every group should only have one distinct ID In the above example Group 2 are...
  17. N

    Data Validation : Allow only time input

    I have a form that different teams return to me giving their total hours spent each day on different activities. Currently some people for example 1 and a half hours work type 1.5 or some do 1:30. I wish to limit input to time format ie 1:30. However these totals can go over 24 hours. The cell...
  18. tlc53

    Bank Account Format - Data Validation

    Hi there, I'm trying to set the format of the cell to format numbers into the following; 00-0000-0000000-000 So when 16 numbers are entered (no hyphens), it automatically comes out looking like this, for eg. 12-1234-1234567-123 But if only 15 numbers are entered, the third to last number...
  19. tlc53

    Data Validation - List + Custom

    Hi, The only data I would like inputted into cell F15 are numbers 840, 841,842, 843 & 844. Also, you can only input into this cell (F15) if cell B15 is populated. Little stumped on this. Can someone help me with the data validation formula please? Thank you!
  20. M

    Prevent duplicates from a range of cells

    Hi, This probably has a really simple solution, but I can't seem to figure it out... I'm trying to use Data Validation to prevent duplicates in some cells. It's easy enough to do this when it only has to look for the value in one spesific cell, but I need it to look in several. I've tried many...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top