data validation (list)

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

Hello Everyone, I am facing a critical problem which I believe require macro to solve this problem. I tried to create the macro so many times but it is not working and not solving my problems. Really appreciate is some body helps me to solve this problem In a worksheet I implied data...

Hello Everyone, I am facing a critical problem which I believe require macro to solve this problem. I tried to create the macro so many times but it is not working and not solving my problems. Really appreciate is some body helps me to solve this problem In a worksheet I implied data...

I am filling out a list of capabilities that have sub-capabilities. A2 is the Capabilty Name A3 is the Sub-Capability name B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A" In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a...

I am filling out a list of capabilities that have sub-capabilities. A2 is the Capabilty Name A3 is the Sub-Capability name B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A" In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a...

I am trying to Print to PDF from a data validation list. I have a pay summary sheet that auto fills when i select the employees name from a drop down list in Cell C6. I need to be able to print off each persons pay summary without having to manually select each persons name Currently i have a...