data validation (list)

Good afternoon all, I have a macro enabled workbook running in Excel 2016. On one tab I've set up a button that runs a macro that will add a new row to a table and set some values in it. Here's the code. Sub ServiceHealth_Tbl() Dim lo As ListObject Dim FinalRow As Long Dim myValue As...

Hi everyone. I have a worksheet that includes roughly 20/25 different columns. Five of those columns contain Data Validation drop-downs to different data lists. I'm having an issue with users of this worksheet copy/pasting incorrect data over the top of the columns with Data Validation vs...

I have two dropdown lists. The first one (D2) lists all the Watersheds in my area. The second one (D4) I need to list all the Sites located within that watershed. See table below. It is preferred that the Sites list only have the site number; i.e. "Site 1, Site 2, etc." I have several...

I've managed to create a spreadsheet for subcontractors (i work in construction) to auto generate document numbers from 18 mandatory metadata fields (Only 8 fields fill the Document number but the others are mandatory to the EDMS system we use (Aconex)). One section is looking for specific...

Hello! How can I set a data validation list such that if the drop down value in the cell is deleted, the cell will automatically show a default value (i.e. "-Select-")? For example, I have a worksheet with multiple drop down lists that I want to show a default value of "-Select-" once the...

Hi All, i'm a newbe so bear with me if this question has been asked and or answered already. Is there a formula that i can use which allows me to select different tabs / sheets using a drop down on my main sheet?. Or a series of formulas that allow me to select a sheet from a dropdown, input...

Hi there guys! Hope that you are all well. This is my first post on MR Excel, so if i do something wrong (not accurate, inappropriate, too dumb, etc) please just let me know in order to improve myself. My question: I have a list of cells ex C10:L10 and C20:L20 and so on, and i need to some...

Hi All, I am trying to implement a change to a spreadsheet, but I am not even sure if the change I hope for is possible. I am hoping someone here may have a solution. I will preface this by saying unfortunately I cannot use VBA to solve the problem as the spreadsheet will be deployed on an...

Hello. I have a list of people who need to select training dates from a list available. I have created a Data Validation drop down menu for the people based off a list of classes available. I have also created FILTER formulas to sort the attendees into attendance lists. My only issue left...

Hi There -- I have a list of 4 values ("Auto", "Multi", "Tech", "Lifestyle") in a data validation list (cell I3, Sheet = "Opportunities"). I'd like the macro below to run / pull data based on that selection. Right now the macro searches through the Raw Data and pulls each of the categories one...

Hi Gurus, I have a requirement where I need to add a macros button to execute a VBA code that will read the string value from a "cell" that contains a "data validation list" with three options ( No Revision, Revision 1, Revision 2) and based on the option selected for that cell from the...

I am using data validation for a particular column. The category list of values is pulled in from a website into a hidden sheet. I did this because I may need to frequently change the allowed values for the category list. The data pulls in correctly and does restrict--in the dropdown options, I...

Background: I have a spreadsheet that works pretty well for tracking events. For each event there are two drop down data validation lists located in column J and column K. The list in column J has values A,B,C. The list in column K has values D,E,F. Each row is one event. For each event, either...

Hello all, I have a data set with about 200 columns and 10,000 rows. Here is a sample: ColA ColB ColC Apple 1 Fruit Apple 2 Fruit Cuke 1 Veg Cuke 8 Green The result set I would like is: ColA ColB ColC Apple 1 Fruit Cuke 2 Veg 8 Green I want...

Hi, I am trying to create a summary section at the top of a sheet I am working on that has a drop-down list via data validation to change the relevant table that is showing the totals (in this case the month in question). I want the sumif function to apply to the relevant table relating to what...

I have a workbook where users can input job titles in two different ranges (A2:A6 & A8:A12). Only one range would be filled at a time, but I want to use one data validation list for both ranges without blanks showing up within the list. The problem is if I use formulas to generate the range for...

I have a list of data and i'm trying to extract info from the list using an index/match formula. This is working but only until I change one of the drop downs from the 1st option to the next and then the answer for the formula is coming back #REF . I think somehow I need to incorporate the other...

I have 2 drop down lists in A1 and B1, both with a “Yes” or “No” selection. How can I make A1 change to “Yes” automatically if B1 is set to “Yes”? I can’t use macros, only formulas, etc.

Hello, I am working on a Workbook_Open formula. Right now the formula works, but it's not forcing Sheet 11 & Sheet 12 to do something. Normally on those Sheets once you click V6 (which is a data validation drop down list) it activates a VBA code for Worksheet_Change which tests if V6=V2 on the...

Title says most of it, I want a drop down list to be sorted alphabetically. Currently I have a Translate Table, in which I have named Column 1 'items' and then a dropdown list using data validation is set to =items. If I add an item to the bottom of the translate table it adds it to the...