dropdown list

I have a list of 1000+ drop down lists (all containing the same options). I need to change the selection for all lists. is there a way to do this that doesn't require changing them one at a time? Thanks!

Hi, I have a dropdown list in cell B11 in sheet1 where I can select values from column A in sheet2. Everything works okay, but I would like to have a quality routine that alerts me if the selected value in B11 exists more than once in column A in sheet2. That is, because this value is used...

Hello, I have two different drop downs located in G2 and G6. If someone picks an item from either one, I want a macro to run that will go to Tab "Formulas" copy the formulas on that page (H10:N10, H15:N69, H73:N129, N133:N232) and paste them in the active sheet that just had the change in the...

I have a dropdown list in column 1. I made conditional dropdown list in column 2. I need to have dropdown list in column 3 based on names of columns 1 and 2. Column 1 is direction. Column 2 is vehicle and column 3 must be crew for this vehicle. Column 3 depends not only from vehicle but from...

I have a dropdown list of all the sheet names in my workbook. I have similar values in the same cells of each sheet. Is there a way that I make a formula or a macro that will use the dropdown list value to select the correct sheet to pull the data from?

Greeting of the day , I would like to combine Countif and dropdown in the same cell , Column1 would be Names of product Column2 i would like to include a dropdown list of equipments that can be used for that product but same equipment cant be used on the same day for another product I...

I have already asked a similar question but I am still not getting the results I had hope for. My goal is to have for instance an entire worksheet that is locked so that other users cannot change anything. However, there will be an exception of cells like C6, C12, C18, etc.. In these particular...

Hi Guys, I wanted information to be split acroos a few sheets. I have four sheets "Main", "London", "manchester" and "liverpool". <tbody> Advisor Date Location </tbody> In the "main" sheet the location column has drop down list of different locations e.g. London, Manchester and...

Hi! I am having trouble finding some solution for my problem. In one sheet I have row based table with data to either be entered with free text (empty cells), or drop down lists where an option needs to be selected. When all the rows are filled, I would like to copy the filled data to the...

Hopefully someone can help me on this one. Have tried looking online for a solution, but to no avail. Haven't done any macros in excel before. I have a dropdown list. Example: 1 - Very Good 2 - Good 3 - Neutral 4 - Poor 5 - Very Poor Once someone chooses an option from the drop down...

I have a spreadsheet (G4:T1000) with a dropdown list in column G. What I'm trying to do, using VBA, is to lookup the value of G in a table (ProgramTemplate) and fill in the columns H:T for that row based on that table. I could do this with a simple VLOOKUP but I need the ability to have the...

Hello, I've been searching the internet for a solution, but not sure one exists: I want to create a dropdown menu which allows the user to select 'red', 'amber', and 'green' and changes the colour of that cell as appropriate. This part I have achieved successfully. However I would now also...

Good morning guys, I am stuck at one point. I have a cell (A1) where I put a dropdown list with 2 choices (simply made by a Data Validation). And I want to run my macro when I change the value of this cell (ON / OFF). If I change something else on the sheet/workbook, I don't want to run it...

I am trying to have a drop down list which only shows filtered records from a table as follows:- I have a "Contact_Details" sheet which has my contacts in a table, including their state and status. In the table, I can use filters to only show records from a certain state, but I am trying to show...

I have a worksheet with a data validation dropdown list which the users will select from. The values contained in the dropdown list are the short (i.e. "user-friendly") descriptions of the values in a larger list. What I'd like to do is, when the user has selected the value they want from the...

Hi There, I have a 4 week trend graph that I would like to make more interactive. I want to have a "from" and "to" drop down lists that viewers can pick whichever weeks they want to see and the chart will update accordingly. Any help is appreciated:) Below is an example of what my data looks...

Hi guys, I am not sure whether it is even possible, but where's a better place to ask than on MrExcel? I have a following spreadsheet: <tbody> A B 1 input 'W' if it is a work day input 'R' if it is a rest day <tbody> Select reason only if necessary </tbody> 2 3 4 5...

I have a dropdown in cell D8 which when selected populates a number of cells but nothing in column F. The dropdown has five options. Could anyone provide me with VBA coding that deletes content in a range in column F and then prevents people from inputting to that range unless the correct...

Hi, the macro below has been working fine to reset a number or dropdowns I have on a spreadsheet, but if Protect the worksheet I get the following error: Runtime error '424' - Object Required How can I modify this macro to run when I Protect the worksheet? Many thanks in advance! Sub...

Hi there! I am fairly new to VBA and brand new to mrexcel.com so please be as detailed as possible in responses (thanks!). My issue: I have a data table called "DataEntry" It has four columns (i.e. fields) - JobType, Rate, Hours, and TotalPayment. JobType is a dropdown list of choices (i.e...