dropdown

hello, i have created a dropdown list which i would like to link to another cell. the data from this cell will then allow a vlookup to operate in a 3rd cell. essentially: - M9 = dropdown list (1, 2, 3) - F6:F8 = cells that dropdown list refers to (a, b, c) - M13 = vlookup on F6:F8 i...

Hi, hope someone can help me here. Im trying to crate a sheet that creates a dropdown of roles based on the selection of a department. Example below of what I’m trying to achieve. https://we.tl/t-oFAukUJE6p Thanks!!

Hello, I've done a lot of googling and can only find references to hiding multiple rows, or based off a fixed cell.. I have a buildsheet that I'm trying to hide a row based off a dropdown list, an example below: Project Management >Included >Excluded...

Hi All, I need a dropdown list with two columns Column 1 Codes and column 2 names Can you help me? Thanks a lot

Hi people, If anyone can help. I have near completed my excel sheet but I'm wondering where my dropdown list is, when a yes or no answer is selecting can the sheet automatically insert new cells for further answers to be entered into the sheet that does not mess up the format of my sheet? Any...

Hi All, I have a strange issue with a dropdown list. I have 3 dropdown list: 1. Dropdown 1 (B5) is independent (static List) 2. Dropdown 2 (C5) is dependent on dropdown 1 (using a named range to get list based on dropdown 1) Named Range Formula: =OFFSET('Drop Down...

Hi, Here's my problem: I have created a list in cells E1-E10 where the 1st entry is "Please select". If A1 is empty, B1 must also be empty. If there is any value in A1, then B1 should show in a dropdown the list from E1-E10. If A1 changes after user selects a value from the dropdown for B1, B1...

Hi, I have a 2 dropdown lists. The second dropdown is (dynamically) populated depending on what is selected in the first (using =INDIRECT). The second dropdown list gets it's source data from 6 columns. The number of rows varies in each column. The first dropdown list gets it's data from...

Hi I don't seem to be able to get this to work. I have created a cell with a dropdown menu in it. The dropdown cell is L9. If the L9 cell says "Cash" then I want the value in cell J9 to be copied to cell M9, otherwise I want the cell M9 to stay empty. I have added this formula into cell M9...

Hi guys, I have a dropdown list on Sheet 1, cell A1 There are many tables on sheet 2, that are named ranges. If I select a value from the dropdown list, then the matching named range on Sheet 2 must be displayed on Sheet 1 cell A3. Any solution is appreciated. Cheers Owen

I have a list of states and their counties. I'm looking for a method to choose a state from a dropdown and a column of their associated counties appears. Or, if the user types in the 2 letter state name and it auto populates the counties. I've played around with dropdowns and v/h lookups with...

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

Hi, Bit lost with this. I have a column L whose cells contain the dropdown options Almost Certain (5) Likely (4) Possible (3) Unlikely (2) Rare/Remote (1) Based on what is selected in column L, I want the corresponding cell dropdown list in column M to populate using following rules - If L...

Please, see attached worksheet to explain what I am looking to achieve. Also, do the headers in Data row have to match the dropdown box?

In the combo Change event I goto my code to do stuff... and the combo box dropdown does not retract. Is there an instruction to make it do that ?

I need help trying to implement a check box to automatically select a dropdown list value when checked, but when it is unchecked i would like to be able to select the value from the dropdown list. So, I have: <tbody> A B C left right left right left right upper ? ? ? ? ? ? lower ...

Hi I have the below code that deletes the dropdown next to it Private Sub Worksheet_Change(ByVal Target As Range) 'K5 Dropdown changes then clear l5 If Target.Address(0, 0) = "K5" Then Range("L5").ClearContents End Sub Howcan I edit the code to delete the below drop down...

Hi, I'm trying to create a dropdown that show a text value e.g. High but has a value associated to it so I can calculate it. https://we.tl/t-GCnCPTCPcA Thanks Matt

Hi all, I am trying to modify a project that I worked on a while ago where a macro would look at each value in a drop down list and export to PDF for each selection. What I am looking to change is adding one more dropdown into the equation. For dropdown A I have 7 values stored (A1, A2, A3...

Hi, I am new in VBA. I'd like to create a VBA script to select the value "associate" from a html dropdown list. Could you help me with writing this script? Here is the html code in the website <h2>Return To Station</h2> <div id="searchUserInputContainer"> <div...