data vaidation

Good Morning, I have an excel spreadsheet where I input certain data per week and for each additional week I have to create a new sheet. I was wondering how could I make it where I could have a drop down of the date and then enter my numbers for the week and it save the numbers I enter and I...

Hi there, I need to create a few dependent drop down lists driven from the results based on Customers. Example: Customers: Honda, Ford, GM, Vovlo, etc... Honda Plants: HCM, HMIN, KTH,KSM, MAP Honda Programs: Accord, Civic, CRV Ford Plants: Monroe, Dearborn, LAP, KCAP For Programs: V363...

Hey i want to Validated a Cell with Only some text. Means the cell only accept some text which i want Like XS-S-M-L And so on The cell which i validated should not accept anything else then that. Can anyone here who can help me out with this Issue.?????:confused::confused::confused::confused:

I am creating an automated work log/invoicing system for a motor repair company. Work is entered into a job sheet and I have various cells where I have set data validation using lists (customer ID, vehicle reg etc). These reference entries in Excel tables. For example, the Customer ID cell is...

Column C in my spreadsheet contains values that will be client-chosen and frequently updated. I want column D to have data validation applied dynamically that pulls from that list. However, it needs to contain alphabetically ordered, unique values. What I am currently doing is using the...

Hi Experts, This is what I'm trying to do, I have three columns with the name as Zone, City and Sale respectively now I drew a pivot and put these things as following, Zone - In Report Filter City - In Row Labels & Sale - In Values Here I am able to view city wise Sale by filtering Zone. But...

Hi experts! I have been trying to make a data validation work. It's simple. I need to be sure, firstly that the data in column I is a valid date. Secondly, if the column D is not "NIT" it should be greater than 1/1/1900. For any other value in column D I need to be sure that the date is more...

Hi, I am trying to use data validation. Is it possible to force a user to enter a number between 30 and 60 or put an NA in the cell?

Dear All, I need some help on IF function. I have a sheet in below format In the Overall results (2nd Image) section ,I want another formula to calculate pass, needed attention and fail ,this should be done by dividing sample size by errors identified For ease attaching file...

Dear Experts, I found myself in a situation of help - I have a file which is attached at following URL https://drive.google.com/open?id=0Bxtc6jUuxe_pY0hoQXBsaWNhOTg So If C24 is Yes then E25 needs a value (from drop down – otherwise it needs an error message to detail the spec). Equally if...

Hi when I was checking my data validation formula I found it failed terribly. The format I'm trying to obtain is: AA##AA####A A is alpha a-z and does not need to be case sensitive # is numeric 0-9 the formula I was using...

Hi, I wanted to create an excel form that has a drop down menu in column A and time stamps in columns B to E (four). I wanted the time stamps to be entered for each column whenever the Column A' cell has been changed from the Drop down menu - which is Step 1, step 2 Step 3 and step 4. I wanted...

I want to create a drop down or a check box where there will be multiple predefined options along with enter text option if none of the predefined data is matched. I can create the drop down using data validation or the check box with VBA, but cant find a solution how to add the option to enter...

Hi! I am very new to Excel VBA. Please help me figure out how to build nested data validation drop down lists. I do know how to build hierarchical data validation lists. The current situation is I have three drop down lists called committees, membership categories and companies, under each...

I have a spreadsheet in which column D always contains substrings of "women's", "women" or "womens" for women's clothing, or "men's", "men" or "mens" for men's clothing. Based on whether the substring is women's or men's, users enter a whole number value in column I, <= 20000 for women's and <=...

Hello, I have a list (drop-down menu) in Cell B7 on my "Customer Info" tab that has 4 options (Flow Rack, Workstation, Machine Guarding, and Other (custom)). When I select Flow Rack in the list I want the Flow Rack tab to turn green and the following tabs turn red. Basically...

I am using an InputBox to ask for variable AcctSelect. I want to set up a simple If Then statement to test if AcctSelect is either 1) "A" or "B" or 2) something else and then exit sub. I need to use the variable later for column selection and anything other than "a" or "b" would throw an error...

<tbody> Column A (Date Ready) Column B (Done?) 28/08/2015 Yes 28/08/2015 Yes 28/08/2015 Yes 28/08/2015 Yes No No 30/08/2015 Yes 30/08/2015 Yes 30/08/2015 Yes </tbody> Default value is a 'No' - however after a date is populated to Column A, Column B can then be made a...

I have been building my own invoices from MrExcel's podcasts. I have a few macros installed and they are working great. Currently I have an invoice "template" for each customer so I have to open a template file for each customer or I have to type the customers information, name, address...

Hi All I am not sure if this is possible, but thought I would ask. On a large workbook I have a column with drop down data validation of "Job position" I would like a way of adding a "name" only if one "Job position" is selected. I am not sure what is the best way of approaching this, I looked...