drop down

Hello! I have this code which works, but I would like to restrict it to just one column - is this possible? It would be massively helpful to prevent users from doing them same in additional columns. Thanks! Option Explicit Private Sub Worksheet_Change(ByVal Destination As Range) Dim...

Hi there. I'm brand new to Excel data validation and VB coding. I'm really excited to learn about what Excel can really do. I watched several very helpful videos and figured out most of what I'm trying to achieve. I'm stuck on how to: How to auto-sort selections as shown in the Target...

thank you for taking the time looking at my post. My question is and how would I achieve the below. As Google hasn’t yielded any solutions other than dependent drop downs. But I only have 1 list and no dependents. Scenario! I have 8 drop down columns side by side from A to H on a row. Each...

Hello! Thank you in advance for visiting my post. I understand there have been a couple posts here already that ask for help regarding VBA code and moving data from one sheet to another based on a drop-down value, I appreciate your help nonetheless. ---------- We are approaching territory...

Hi, I have below sample table that has different teams and managers, what I need to do is, when I select specific team and manager from the drop down menu, the categories list should be updated based on selected team and manager, can anyone help? I have another challenge, each team has unique...

Hello I need to have a multi select dependent dropdown list. And as an example below. Can anyone help please?

Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...

I am making a bracket for basketball teams by region. I select the winner of the game based on a list referencing the named ranges you see pasted below. I pull data from multiple web queries into each regional bracket and have many formulas. Because of this, its quicker to copy the sheet and...

I am brand new with VBA code but from my google searches, this seems like what I should be using. I’m hoping someone can help me made this worksheet. I’m trying to design a sheet that will keep track and display the number of ports on my circuit. The rules are I can split each port 3 times. So...

Can anyone please help me, I am trying to make a works roster simple by adding drop down menus in cells, rather then typing everything in. I have the following in two columns on Sheet 1 and the roster on Sheet 2 Work Title Required WORK...

Hey Everyone! Here I am again... I am not entirely sure this is possible but let me try to explain what I'm looking to code: I have 2 option buttons: Canada [Op1] & USA [Op2] I have a Drop Down List with all provinces listed and states in cell G33. What I want is for only the provinces to...

Hi, I am a total beginner in VBA. I have an excel with two sheets as "form" and "database" (actually more but others are not relevant). In the Form; 1) Users type their username, password, and select the week. 2) In the orange part, users type other stuff (to all 3 rows). 3) When submitted...

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

Hello, I am working on a spreadsheet/workbook and was wondering if anyone could help with my issue. I have a drop down in column 1, it'll then give me a drop down list in column 2, which autofills column 3, and finally gives a drop down list of coding in column 4. I have my drop down/look up's...

Hi. I am struggling to find a way to create multiple drop downs that use just two columns. Using the data below for example, I need the first drop down to select the type of food. The second drop down to filter the colour. Without having to rearrange all the data. (I have 1000s of rows of data...

I am working on putting a template together for my company and ran into a problem with having two dropdown lists. The goal is to have that ever is selected in list 1 to populate only a set list of items for list 2. The spreadsheet attached i am working in column 'H' & 'I'. the code form column...

Hi, I have a data table of financial securities, each item(row) corresponding to a certain country/region of issuance. I would like to have that table filtered automatically to show only those securities issued from a specific country and region selected from a dependent drop-down list...

I am trying to create a drop-down list for every cell in column "S", using data from cells in column "X". I have successfully created one for the first cell (S2), but how do I duplicate this menu for every cell in that column without having to laboriously create a new individual menu for each...

Dear forum, I have a macro running all fine until a point where I have code to add dropdown "Active, Inactive" option to column BK. The macro runs up to the naming of cell BK1. It stops there and doesn't execute the dropdown code. However, if I run just the dropdown code only in another...

Hi everyone, Here's my problem. The objective is for people to only be able to touch a cell if a condition is met and they have to select from a list. Example: people using this excel will only be able to write in cell C2 and choose from a drop-down if B2 = "lalala". I thought about doing it...