drop down list

Hi Folks - Thanks in advance for taking the time to look at this. I am trying to create a drop down list from a large range of data with lots of duplicates. Is there a clever way of doing this without having to first extract a unique list using a unique filter formula? This is what I am...

Hello Community Members, My name is Emmanuel Katto, and I’m reaching out to seek your expertise regarding a challenge I’m facing with Excel drop-down lists. I have a workbook where I am trying to create dynamic drop-down lists based on the selection of another cell. For example: Cell A1...

Hi there, I have a spreadsheet with input pages and then various tabs for the respective reports. Not all report pages are required, and some are hidden (not visible) based on the users' selections on the setup page. I have a formulated a drop-down list, which shows the reports available for...

Hello, I have an excel sheet I use for a golf leage that I run, I made some changes to the list of team this year copying and pasting into a few of the teams lists which seems to have broken some links. I don't jhave any contact with the person who helped me creat this initally, and due to an...

Is there a way to change the box/arrow attached to a drop down list, to an image/shape? Basically, instead of clicking on the arrow & box to activate a drop down list, there's a small image or shape that can be clicked. Same functionality as the regular drop down list, just change how it's...

Hi I have 3 different tables: Stage 1, stage 2, Stage 3 I want to display one of these tables when a certain stage is selected from a drop down list or when entered into a specific cell. I want to do this on a separate (Summary) sheet. Is there a function or way I could do this? Thanks very much

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

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

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

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

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

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

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

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

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

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

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

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

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

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