dropdown list

Hi! I've been breaking my head trying to figure out and or find an answer on how to use a drop down list (of names) to fill down a column with the results. More detail. Lets say I have multiple sheets, each with a name, an a list of objects they own like this: And on another sheet, I have a...

Hi, I have a dropdown list in cell A1/A2: A2 refund A3 no refund Now, refund/no refund have a value in I1/I2: I1 4000 I2 5000 I want to be able to multiple a quantity (it will be in cell B2) by the selection of the dropdown list, for instance: If i select refund, i want to...

Hi Everyone, I am having real problems calculating values based on certain drop down selections I make. For example, for my business I am trying to calculate the spend per year by selecting a drop down and choosing the year I want to be calculated. I already have the spend data for all the...

Hi guys, I am trying to create a sort of flow chart using dependent dropdown lists. I have managed to get 3 dropdowns working, but I am struggling with the 4th dropdown. In this example: A2=ProductList B2=INDIRECT(VLOOKUP(A2,ProductLookup,2,0)&"List")...

Hey Guys, I'm quite a newbie on this. So, I need button when I click, it will go a specific worksheet (within same workbook) depending on a dropdown list. example: dropdown list say 'Freq Change' when I click the button, it goes to the 'Freq Change' sheet I will have multiple sheets like this...

Hello brilliant minds, I maintain a workbook with Tab 1 being a staff list with role/titles and pay rates, and I update this as rates change or people get hired/leave. Subsequent tabs are devoted to different grants, and I use the info from tab 1 to schedule hours for each grant-funded project...

Hey all! Hopefully I will find some help here. My excel sheet tracks different task items in rows and one column is to "Mark complete" as this is a shared file. I already created the dropdown using Data Validation with the Wingding 2 checkmark but I'd like the text in the dropdown list to read...

Is it possible to convert a cell with concatenated names (John,Peter,Mike,Philip) into a dropdown list: John Peter Mike Philip Thanks for helping out! Gr. Sander

I have a file with a worksheet that uses 8 separate dropdown lists. I need each dropdown field to allow multiple selections from the dropdown list and hold the selections in a separate cell. Example dropdown list in worksheet2/column T dropdown displayed in worksheet1/A65 dropdown...

Morning all, I hope you all had a great weekend. This newly created thread follows this one. I wanted to filter the range D4:D590 by value selected from dropdown list located at the cell DK1, which has been solved by Fluff and fadee2. I used this code for it: Private Sub...

Hi Everyone, I have an Excel Workbook 2016(.xlsm extension) with macros with Multiple Worksheets. I have Dropdowns in many cells with options to select the answer but I am facing issue that Dropdown list is not showing when I send this Excel Workbook to others. Also users are able to enter any...

Dear community, In Excel, I am building a small database with information on employees, clients, invoices, etc. I have a separate file with some macros that I use to generate invoices. There are 3 things that I would like to have, where the first is required and the other 2 are nice to have...

Students names ( on normal cells) changed automatically when i select a class from dropdown list : How can i do this via formulas or via vba? for example: "dropdown list " : [Class 6-1 Class 6-2 - Class 6-3 ] Student name 1...

Good Morning, I hope that this finds you all well. I am working on a project where I want to create a drop down in the cells so that users only can select one value from a pre-defined list. What I would like to do if possible is since the value that will be stored is a code, in the menu I...

Hi everyone, I am trying to build a formula, but no luck. In the yellow cell (N5) I have a drop-down list of months that I can choose from. Currently, month "feb" is chosen. Now, I would like to get max value from the table below, from row coresponding to month "feb", so in this case from...

I am trying to automate data download from FFIEC website using VBA. I am not able to make a selection in the dropdown list "Reporting Period End Date or Year" on the webpage using the following code. The dropdown list gets updated based on selection you make on the ListBox1 above it. Would...

Hi All, I want to create many dependent drop list (more than 100) that auto refresh when the source list changes. I am able to auto update the list using data validation and by changing the source list using named ranges but the selected item doesn't change unless I re-select the data...

I have an excel sheet that 6 columns have data validation, (drop down list), i want the width of the drop down list to expand when is selected the following VBa code worked for me but is only for one column is there any way to do it for 6 columns the VBA code is the following Private Sub...

Hello everybody! This is my first time posting a thread and I really hope someone here can help me quick enough. I have the following "table" (in quotes bc I couldn't format as an actual Excel table) that brings 3 identical subheaders categories (ADDRESS, EMPLOYEES and EMPLOEMAILS) to each...

Hello. I am in need of some help here. I have 2 drop down lists on my spreadsheet. what I need is so when I select an entry in drop down list #1 for the other drop down list #2 to clear. Vice Versa I also need the same code to clear drop down list #1 when drop down list #2 options is...