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

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.

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

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

I have 8 excel sheets (basically all quote sheets that have product listed with options that can be added on listed by category. I.e. Product lists are Truck, Car, SUV - Options Categories are - Radio, Interior color, Exterior color Then each category has multiple options to chose from I...

Hi there, Before I go back to the drawing board, can anyone see whether they can get this VBA code to work? Basically, I have two drop down lists. One is "No. of Investments" and the other is "No. of Partners". I would like certain rows to hide, depending on the result of both drop down lists...

I have a work sheet with several columns, one column has the position titles (column B) of my reports this is chosen from a drop down list. <tbody> A B yes Chief no Operation Specialist no Operation Specialist no Control Engineer no Startup Engineer </tbody> What I want to do...

I am trying to auto populate a group of empty cells with specific selections from a drop down list. The total list contains five entries, two of which I want to populate the empty cells when they are selected. I have tried the =IF formula, but it only seems to work within the same sheet...

Hi, I am trying to compile a stock list document, what I would like to achieve is to have a drop down list which pulls in data from a different tab. For example, I would like to have a drop down list populated with; apples, bananas, oranges. On another page I will have 3 tables of apples...

Hi All I'm looking to run and repeat a macro the uses data from a drop down list until the list is completed, here's the details. On Sheet 2 B1 a drop down list grabs data from AS1 down, here's a breakdown of what I'm trying to achieve: Step 1: select the first item on the drop down list Step...

Hi Although i can find threads similar to my situation, I can't find one that gives me enough to solve my issue on my own and so could do with someones help please... Simplest way to explain is giving you the basic file example which is here on dropbox in essence, there are three drop down...

Hello, I am currently working on displaying and hiding all other columns in a range based on a drop down. In row 7 I have all the columns identified by text, which is the same as the drop down list. When an user selects the drop down, the sheet should hide all other columns except the one...

Hi New to this forum & Excel. i am currently trying to make a customer spare parts quotation but have an issue with selecting "customer" "machine" "serial No." drop down lists. <tbody> CUSTOMER MACHINE TYPE SERIAL No. JOE.BLOGGS MC TYPE1 1234 </tbody> My problem is:- we have 4 main "types"...

I have two dependent drop down lists and I want to insert a function/macro to toggle through each possible option on the drop down list at random. Any help would be greatly appreciated!

Hello, I am currently trying to write a macro that will take a shifts daily output and place it in a daily log that will be progressively kept through the year. The workbook submitted by my Supervisors has the date, a shift drop down with selections (1ST, 2ND, 3RD) and four different products...

Hello all, This is one of my first posts, so please let me know if I'm not doing it correctly! I read the forum manual but still, I am human and I make mistakes.. My previous post was approved so I hope this one will be as well. So here it goes.. I have a userform which can copy specified...

I want the ability to create a list using data validation and give it a define name. With this I want a drop down menu that will display a title but once selected give a code. Here is the code I have right now: <code> Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1...

We are currently using Excel 2007, The spreadsheet has a lot of different calculators involved and would like to protect the sheet and have only certain cells accessible. I created a form control drop down box that lists about 30 different vendors, the users would click on the drop down to...

I would like to subtract a number according to Drop Down list options. My Drop Down list is in colums B4 to B20 and each column has the same tree options: A-B-C , and there are columns D4 to D20 and F4 to F20 each column with numbers in reference to those options. Columns G4 TO G20 are the...

Hi all, I've been looking up how to do this online, and I haven't had much success, so hopefully someone can point me in the right direction. I am trying to create a few drop down boxes on a userform, and am trying to make the values a range from my sheet. The three drop downs will be for...