drop-down

I have a simple query setup. =Query('Data'!A2:O, "select A,B,C,D,K,L,N where K='No'") I would like a way to toggle this query off and on. I tried putting a checkbox in A2 and added IF(A2="True" before the query but that doesn't work. Almost got any ideas? Ultimately I'd like to have this query...

Hi I have a workbook with 2 worksheets - (A & B) Worksheet B holds a list of teams, I.e. Team 1 in Column A, Team 2 in Column B etc.... On worksheet A, in Cell A1, I have a drop-down with all the relevant teams on worksheet B What I would like to do, is: If for example, Team 1 is chosen from...

Hi I have a CB1 combobox, the problem is: I want to trigger an event ONLY when I click on a value in the drop-down list. There's a FilterTheComboBox sub that filter as I type in the dropdown list. For example, suppose a dropdown list with: "House", "House A", "House B". 1) Using MouseClick...

Hi, I have a sheet set up which changes colours of cells based on Dropdown box value Problem is I have 5 drop-down (1 for each day) and people copy paste from Monday to the other days and it breaks the formatting Example A2: user input B2: user input C2: drop-down box ( option sets...

I'm trying to get the comments from the cells that are on another sheet to appear when my users hover over cell where drop-down list is. Please help, Mike in Cali...

Hi Everyone! :) I am trying to create a macro for the below steps but I am new to using this tool and facing issues. Could anyone please help me with this? In cell D2 of Sheet1, I have a drop-down list with 3 items. In cell D3, users can input a number (0-55). In cell D4, users can input a...

I'm trying to create a reforecast model that will automatically update values based on the month that appears in a drop-down menu. I have the drop down menu created -- it's just a matter of getting the formula to pull the correct value. SHEET 1 has the months in column C through N (row 3)...

When I have the first line of code, the if statement works. When I add the second line, I get a #value error for all selections from the drop-down box. I do not understand what id wrong with the logic? =IF(OR(A3="GE",A3="GEL",A3="SR",A3="SRL",A3="VIL",A3="VP"),IF(AND(B15>0,B15<200),"CF <...

Hi All, I would like to use Excel to create a comparison table, the idea is that in first sheet, it provided three drop-down list for user to select, the list items is related to another sheet database. Once the user selects one item, its related information contained in the database will show...

I would like to fill cells A3 to F3 with light red or green according to drop-down list selection. In the drop-down list F3 there are two options´Buy´ or ´Sell´, if ´Buy´ is selected then cells A3 To F3 will have a green fill, if ´Sell´ is selected then cells A3 to F3 will have with light red fill.

Hi, I havecreated a template for my staff to use. I've written code that generates aunique sequence number and saves the file but I am having trouble when it comesto removing any information that may have been pre-existing on the form. I amcurrently using the ClearContents command but I've found...

I'm looking to enhance my conditional formatting to highlight the cell in column C if the content is not an option from the drop-down fields specific to another cell. My spreadsheet has two columns with different drop-down fields. Column B is the subject and column C is the Type, below is an...

Looking for assistance on the following: I have a basic drop-down list which has a choice of Yes or No. I am trying to write a formula that will check which was selected in the drop-down. If the choice was Yes, then x, else y Is this possible? Thank you!! -BB

Here's the details: Let's say I have a drop down list in 1400 rows of column Q. The drop-down list is populated by a named range, COLORS. I was a drop-down list in every cell of the 1400 rows of Col Q. Easy enough. Here's the rub: The first item in the drop-down list is RED. If a user selects...

I recently created a small database full of NFL players that is split into different positions (linebackers, cornerbacks, quarterbacks, etc.). I also have a spreadsheet in it dedicated to finding a best comparable player at their specific position. In this sheet, there is a list of players at...

If I select a certain item in a drop-down list, is there a way to populate a certain item in another cell that has a drop-down list?For instance, let's say I have a drop down list in A1 which lists RED, GREEN, BLUE. If I select RED in A1, if B1 has a drop-down list which lists 1,2,3, can I have...

If "red" from a drop-down list in A1, then "certain text" in B1, else a drop-down list in B1. How can I do this with VBA? I want to create a drop-down list in, say A1, which returns RED, GREEN, or BLUE. If a user selects, say RED in the drop-down list in A1, then I want another text string to...

Hello all, I am trying to put together a sign-off sheet of responsibilities within my organization. To do so, I've created two cascading drop-down lists via Data Validation: Independent Drop-Down: Department within the organization Dependent Drop-Down: Position in the corresponding department...

i would like to add a drop-down box (similar to the built in filter drop-down) capable of selecting a value or multiple values in cell U2, then if V2:DE2 = the selected value(s), then hide/unhide that column(s) based on what is selected or not in the drop-down. can this be done?

Hi, I've been attempting to lock/unlock a range of cells within a spreadsheet depending on the value selected in another cell. I have tried many different suggestions, and have made sure that the sheet is unprotected, but am coming a bit unstuck. Any help would be much appreciated. The closest...