data valiadation

Hello All, I have UTFSE however i really am having difficulty explaining this issue so please bear with me. I have a list of products and its used for Data Validation, the idea is i can just select the product name, the next step is to be offered a list that will only show me the relevant...

Hi Guys, I currently have an order sheet for multiple customers. The AC Number goes into Sheet1 C2 and you select the product type from a drop down list in C3(the information for the list is on sheet 2 H2:H6 . ) my problem is that no matter which ac number goes into c2 you can still see all...

Is there a way to stop excel from calculating BEFORE it runs the data entered through data validation rules? I don't want users to see a mess on the screen. I have an excel sheet with various data validated cells. Excel is correctly throwing the Stop Error alert when incorrect data is entered...

Hi all, I have a bunch of information copied from the internet in a nice structured table. I am trying to create a separate table that a user can make selections using data validation drop downs. These drop downs will be dependent on what the user has selected previously. I have done...

Hello, I'm trying to use data validation to validate if the user provides a 8 digit HEX value. In example data validation in cell K2: Allow: Custom Formula: =AND(LEN(K2)= 8;ISNUMBER(HEX2DEC(K2))) This works but I can't manage to replace the formula with ROW() in order to use it for all my...

Hi, I have three branches. Each start operation in different month Say Jan, Feb , March. Monthly Sales of each branch is 15000. When a new branch start operation it follows a predefined revenue percentage pattern. E.g. 10% in first month 20% in second 30% in third and so on and eventually...

Let me start by sating I'm fairly versed in Excel, and have been trying to figure this out and searching for an answer for almost a week,:confused: so any help at all would be GREATLY appreciated! I found these two codes (the top two) in the forums, but can't seem to get it to work while saving...

Hy all I have a question very important and for me very hard I have 2 Data Validations in Sheet2. Data Validation A (Machines, about 72) Data Validation B (Molds, about 596) Machine 1 does X,Y,Z molds Machine 2 does P,Q,R molds Machine 3 does Q,W,E,R,T,Y molds ... Is there any function or...

Hi All, I am currently working on a confidential file (so unfortunately cannot do any kind of file drop) so I will try to explain my issue to the best of my ability. In cell C3 I have a prefix for a part number, for example: 9831. In cell D3 I have a suffix for a part number, for example: 0000...

Dear Experts, I tried to solve above problem using Data Validation formula but it does not help as per my wish. Because data validation does not work if somebody copy paste the duplicate values,it works when somebody types duplicate values in next column. So if I want to enter lot of urls to a...

Hi all, i am in need of some help please with an old favorite. i have done this in the past but can't find my old worksheet to cheat from. So, i have 2 worksheets that i am currently working on. First sheet is call Daily Input and the second sheet is called Data. The data sheet has name ranges...