drop down list

I have a combox box that allows me to select a worksheet name from a drop down list and then it takes me to that worksheet. That part is awesome. It works in conjunction with a command button. The command button generates the combobox with the worksheet names. This part is not awesome. My goal...

I have 3 drop down lists. The first cell is the product, second cell is the make and third cell is the model. Cell 2 is dependent on cell 1 and cell 3 is dependent on cell 2 However, when I delete the first cell I want the remaining two to reset back to empty. The only way that is possible...

Hi, How can I select multiple value from a drop down list. Below is the code which I am using for drop down list, but I am not able to find out the way to select multiple values. Please help. If ActiveCell<gs id="0a4e658b-78e8-49e2-a442-66e76086674a"...

I have an existing spreadsheet which has product information along with sales information. The sales information is grouped by manufacturer number. My end users want to also see the corresponding sku (i.e. product ID); however there are some manufacturer numbers which have more than 1 sku, so...

I'm sure someone else has posted this but I just can't find it. I'm on Excel 2010. I am creating a series of drop-down lists, one for each column. In A1, the drop-down list is composed of cells A10:A11. The B2 list is composed of cells B10:B11, and so forth. When I create the list using data...

Hi, I want to create a purchase order generator system in excel, I have created a basic template and got to a stage where I'm stuck for ideas on how to proceed. Basically I want the purchase order to work in a way that, once a supplier is selected from a drop down menu, the product codes...

<tbody> I'm looking to sum totals in a drop down list as follows:In column C (lines 7 - 38) I have a drop down list that assigns categories to that particular line. In column F (lines 7 - 38) there are totals that apply to that particular line item that are numbers. These totals change with each...

Hi, I have a table (simplified below) where I am tracking shipping containers. Id like to create a drop down list (using conditional formatting) of container numbers where the status is not set to DELIVERED on a separate sheet. The idea being that I can create an auto filling container weight...

Hello all, Thanks in advance for the help. So I’ve created a range of cells which contain drop down menus based off of a list created using Data Validation. The drop down menus work and contain the information from my list. While at the top of the spreadsheet the drop down menus show every...

Hi everyone.i have a drop down list with validation data.it cant be locked because user cant select from the list,and since it is unlocked user can delete the contents of the selection cell by del key on keyboard.How can i prevent this issue.Your help would be highly appreciated.

Any advice on a question I have. I have a simple table that has data in it Area (D2) Title (D3) For the above, D2 already has a formula that says =summary!L2, which is linking in from a previous tab which has a vlookup formula. What I want D3 to show is a list of titles that are listed on...

Hi All, I've been trying to find an array formula for a dependant drop down list I saw a few years ago. Basically, I have three Source columns (Category, SubCategory, Details) that I need to work with. Constraints: Must not use VBA, Helper Columns, Macros Source is not defined as a Table...

Hello, I am trying to create a drop down list of ZIP codes and then, depending on whether someone says "yes" or "no" to a question, make a recommendation as to the best organization to contact. This recommendation would change based on the ZIP code. I have the drop down list set up and have...

Hi all, On my first sheet I have a drop-down list that selects which week of the year we are on (17, 18, 19, etc.). Then on the second sheet, each week is broken down into 5 days, 1,2,3,4,5. The cell above these 5 is merged with the contents "week 18" for example. I want to be able to select...

Hi, I am wondering whether it is possible to have a drop down list based on the value of another cell. I have already created dependent drop-down lists, but now I am facing more of a "if this cell has this value, create this drop down list, otherwise don't let the user enter a value". Here are...

I have a worksheet with multiple drop down lists that allow for multiple selections. The sheet loses this functionality when I protect the sheet. I need to keep the sheet protection as the document is going to be utilized by many people. I don't want them all making changes. How can I fix...

I have a lot of drop down lists (using "data validation") and I'm wondering if there is anyway to have tooltips for each option in the drop down list?

Hello friends, I'm using Excel 2013 and I'm trying to create some drop down lists like in the following example: https://www.youtube.com/watch?v=rLRrYPsxGa4 Here, when i'm choosing the city, let's say London, i would like to see all employees from London city, in a clear list, not in a drop...

Hi again! I'm having some difficulties setting a range to use in a dropdown list. There's no problem as long as the range is continuously ("A1:A10" etc.). However, in some instances the list will have more than 100 items in it. So I've created a script that finds the cells containing the...

Hi all, I'm new to MrExcel and also new to using Macros in Excel and VBA. I want to be able to select an option in a drop down list in cell F3 (range from 1 to 9) and depending on what option you select, two dates would appear in cell B3 and D3. I've heard of using worksheet_change but I...