data valadation

hello Im trying to build a data base of parts warranty info. what im looking to do is when I select a part number via drop down menu in the 'part number' column, the corresponding description and cost columns in the same sheet are automatically filled in. my image below... the PN# column is a...

Hope someone can please help. 1. The Conditional Formatting code below works on this one sheet with Sheet Protection Off. However, with Sheet Protection On, it generates "Run-time error1004: Application defined or object-defined error". Please see this video for details. Note that I neglected...

I have to make a few hundred forms to various e-mail addresses, but I would like to prevent empty answers. I used "Data Validation" option (unchecked "ignore blank"), but you must enter the cell to activate this, if you don't enter you will not trigger validation. I tried to find the VBA code...

Hi there! I am having some problems with data validation through VBA. The "Age" column should have several data validations, depending on which method was selected by the user should look something like this (refer to image) here is my code Sub DateOfBirth() Dim FORM As Worksheet Dim...

Hello Everyone, I am trying to generate an All-in-One sheet which will auto-populate templates as sheets based on the product type chosen. Currently, we share a single Google Drive folder containing 450 templates, and they chose which to download and enter values. Each of those excel files...

I have a column that is supposed to have dates entered, and is formatted for short date. The condition is: any date entered must have occurred in this year or a later year. I have entered the XL2BB code below and a screen shot afterwards. The problem is that dates in previous years are accepted...

Hi guys, I wonder if somebody could help me with this. Using data validadtion I would like to have the Help button open a message bpox of whatever code I would attach to it instead of going to the Microsoft page. Is that even possible? Thanks in advance, I'm using Excel 2019

I want to create a list with data validation taking unique values of the column #date of a table

Hey all, I am needing to shorten this formula so I can put it into a data validation drop down list. =IF($c$11="1", 'LI'!$A$9:$A$99, IF($c$11="2", 'LI'!$b$9:$B$99, IF($c$11="4", 'LI'!$d$9:$d$99, IF($c$11="5", 'LI'!$e$9:$e$99, IF($c$11="6", 'LI'!$f$9:$f$99, IF($c$11="7", 'LI'!$g$9:$g$99...

Hi there, I'm very green to VBA and am trying to write a code to run multiple data validations in tables, each with their own hard stop error message. The spreadsheet is a data entry spreadsheet and here are the rules: 1) data entered in cell must be numeric - Shading cell with light red color...

Hello, I've a "search" page that loops through all the sheets to return data to my search page and produce a hyperlink to each sheet said data is found. One of the search criteria is from a data validation list. I believe this is messing up the ordered list of search results. I have the code...

I'm fairly new to excel. I have googled this with no help. I will try to explain this the best way I can. I have a field that I created a dropdown from a named range. I then want to use the value selected to create another dropdown list, but its filtered to only display certain values from the...

Brand Shipment Code PH 7 digits PC 8 digits Okay! PH and PC are two brands in my logistics organisation, the thing is the shipment code of PH is 7 digits and PC is 8 digits what I want is when i enter PH the shipment code should only be 7 digits if its more than that then it should...

Hello, I have a data validation set up from a range of cells by formula SUM($B$2:$G$2)<=1. In other words, I want an error message to show up if the total for cell B2:G2 is greater than 1. Is there an easy way to apply this to B3:G3 all the way down to B166:G166 without having to do it one at...

Hi all, Note: I already posted this question on Stack Overflow, but I guess that post there isn't going anywhere, so I think it's time for some cross-posting. I have a dynamic list of category options I want to present in some cells using a data validation drop down. This list is ('admin')...

Hi all, I’ve got a sheet with 4 tables on it. I have a cell in B2 with data validation set to a list on another sheet. I can currently hide or show the tables based on either columns or rows. As one table is shown the others are hidden. What I’m wandering is if it is possible to hide or...

Hello everyone, I have two name range lists as follows Fruits Orange Apple Banana Coconut Apricot Vegetable Cucumber Eggplant Pumpkin Squash Tomato I am looking for a solution to use the above lists under data validation with if condition. For example If i Put...

Hi, Calling all Excel geniuses, I’m working on a project for a friend, I’m already way beyond my comfort zone in Excel, and am have an issue that I can’t get around. My project involves making a sheet that acts like a form with each row being a series of dropdown menu’s (to limit the users...

Hello all, I have a spreadsheet with a number of companies, each one with 3 specific values that I would like to be able to put in and out of spreadsheets. When I select one of my companies using data validation list I would then like the 3 corresponding values to automatically fill in the...

I have a sheet within my workbook where I'm trying to do a couple related things at once that I think may be messing with each other. I am applying data validation on the fly first -- in other words, every time I click on a cell in a given range on my sheet "User Lists" it checks the header of...