drop down list

  1. H

    Dependent Drop Down Lists

    Hi all, hoping someone can help with this one. I'm currently working on a spreadsheet to track training data, and one thing I'd like to add is a dependent drop down list for the training provider. It would have a drop-down list in Column J to select the "Provider Type" (either external or...
  2. E

    Horizontal dependent drop down list with unequal amount of supervisors.

    Hi all, Trying to create a dependent drop down list, but ran into some issue. I want to create a drop down list that is dependent on a previous drop down list. The first drop down list includes the management unit, which is already working fine. For that I created a small macro that retrieves...
  3. M

    Hello, I need assistance hiding used items in a drop down list

    I'm using multiple columns to place each employee where they are scheduled. I have the list of employees on a different tab labeled employees from a3:a62. Thank you
  4. T

    Drop Down List Unprotect/Protect Sheet

    Hello all, I have a sheet with a drop down list made using data validation. The value selected in the drop down list functions as the lookup_value for a bunch of vlookups. I'd like to "protect" the sheet in some way as the users are not necessarily Excel savvy and I don't want the vlookups...
  5. D

    Hide Used Items in Drop Down List

    Hi there, I'm trying to get drop down lists in different cells with ability to hide used names (names of employees that were picked already). I want to have drop down lists in every column with name TEAM - once name is selected I want it to dissapear from other drop down lists. Is it possible...
  6. O

    VBA Code Not allowing multiple & repeating selection

    Hi, so I am trying to find which item was purchase for each order. And so the drop down list in in column C and I am trying to allow multiple selections with repetitions. But once I put in the code, for some reason it would either NOT update or the code is not working. This is a code I found on...
  7. H

    Filter with multiple criteria dropdown list

    Hello, I am currently working on a spreadsheet with many data, including a dropdown list with multiple selection (I used a VBA code to activate it). Now, on another sheet, I need to extract data from the initial one by using the dropdown list as a criteria, but the advance filter is not...
  8. J

    Dynamic Valuelist based on selected dropdown

    I'm fairly new to excel. I have googled this with no help. I will try to explain this the best way I can. I have a field that I created a dropdown from a named range. I then want to use the value selected to create another dropdown list, but its filtered to only display certain values from the...
  9. M

    How to increase the width of an Excel Drop down list and have it display a different value while on SharePoint.

    I am new to the forum but I am having a challenge with finding a solution for my situation. I have an Excel (Office 365) file that is hosted in SharePoint. It is currently formatted with Drop down lists based off of a named range. The drop down list is applied to cells E9:AI889 on the...
  10. B

    Limit in excel data validation source code

    I have an excel file with two sheets. The second sheet (Report) contains data validation cells based on the first sheet (Data). From the second sheet, the drop-down list that displays in the Select XXX depends on the selection in the Generate Report. When the Generate Report is set to anything...
  11. C


    Hi All Is there a way to get snapshot of a cell if it is changed. So dropdown list in E1 and i want a snapshot of that cell if it is changed in Cell P1 Is this possible? Thanks
  12. Y

    Clearing Dependent Drop down list Excel with VBA

    Hi Everyone, I am found a macro online that would allow to clear a dependent drop down list, but it doesn't work. I have a parent list that is merged from M7 till O7 and then a list that is dependent on it and ranges from Q7 till S7. I also have a list that is depenent on the list from Q7...
  13. M

    Shrinking Data Validation Drop List with a column in between

    Hello All, This is my first post, I've looked though the forums and I've found some items that come close but not exactly what I'm looking for. I'm working on shrinking drop down list with data validation. I'm able to get it working while using 1 column and adjacent columns, the issue comes...
  14. B

    Hide/Unhide Row based on dropdown value

    Hi all, I'm extremely new to VBA and need assistance. I have 2 worksheets; Worksheet 1 has is a list of all employees in both department "A" & "B". Worksheet 2 is a list of employees from department "A" & their tasks for the day. I would like to create a VBA where I can enter all of my...
  15. B

    Combox properties missing (Linked cell, Listfield range)

    I've a basic knowledge of VBA but new to control boxes. Trying to follow instructions to create a combo box but fields I need aren't showing under Properties, the alpha-betical list showing is: ... Left ListRows ListStyle ListWidth Locked etc I need to use: LinkedCell ListFieldRange in order...
  16. M

    Data validation to disallow blank entry when using drop down list

    Hello, I can't believe nobody has asked this question before but I've looked through past posts on this topic and have scoured Google and cannot find an answer. I have data validation on a cell that uses a range on another sheet to populate the drop-down list. All I want to do is make it...
  17. D

    Drop Down List

    Good Day my brave excell'ers! I have a sheet (Sheet2) with the list below [Sheet2] <tbody> a b c 1 Bob obs tech 2 mark nav elec 3 john tac mech </tbody> On [Sheet1] I'd like to have a Drop-Down list in A1, then when a name is selected it populates (B and C) with the relevant...
  18. D

    Drop down data not loading when running power query

    I have 4 workbooks. Each contains two columns of data pulled from drop-down lists. When I use Power Query to combine the workbook data, everything comes over except from the two columns that contain drop-down data. How do I get Power query to pull this data over? Thank you.
  19. R

    Special Drop Down List

    I'm looking for a way to setup a drop down menu that will give a sub menu depending on the primary menu selection and i need the sub menu item to be removed after it has been chosen. But, if I check a box that turns a cell to a TRUE value it will allow the sub item be used again (add it back to...
  20. tlc53

    Drop Down List - No.1 to No.10, non-repeating

    Hi there, I would like to have a drop down list with options No.1 to No.10 but once a number has been used, it is removed from the drop down list. I have found one way to do it but I'm hoping there's a better way. Drop down lists go in cells D180:D260. Currently my data validation list is...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back