drop-down

Hey all, I hope you're all well? I have a quick question that you'll find very easy I'm sure. I have a VLOOKUP with a MATCH formula that is grabbing data from a separate sheet based on a drop-down list. Now the issue I'm facing is the data it's coming back which is both a NUMBER or a...

Hi guys, I want to create a 2-item drop-down such that when you select each item it will populate the following 11 columns with pre-set values related to that item. Here's the sheet as it stands, which we've been populating manually by copying and pasting... I want to make the "TX...

Hi there, I'm working in excel 2016 and have a simple spreadsheet with rows and rows of data and have filters on all columns. I noticed that the drop-down box on any of the columns does not list all the data. I have removed blank rows, however the drop-down on the filter is still limited. Can I...

Hi there, I am working in excel 2016 and wondered is it possible to increase the size of the drop-down box to match the size of the list in the box or even to make it bigger than it already defaults to? Or is it a pre-set size and can be adjsuted? Any assistance would help and save me...

Hello all, I've been finding past forum threads useful to learn from others' experiences as I get the hang of Excel. Maybe someone can help me with a question of my own? I have a drop-down list in A3 of my Excel spreadsheet (version 2010). I'd like my user to be able to select an option from...

I have a data validation list for every cell in a column. The source for the data validation is dynamic, so that whenever you choose one parameter from the validation list, it gets removed from the source list. Because of this, when I go to a second cell and click on the drop-down menu, it...

Hey All, I'm creating a service schedule. The schedule would have a list of service engineers and show what customer's they are at throughout the year. The whole year with days of the week and dates would be on one sheet. On the far left most column from top to bottom, I have the year which is...

Hello everyone! I have been asked to take a stab at creating a small GUI to look up data vs. Filtering data in excel. The reason I am doing it this way is because I will be summing totals as I click on certain people. I created a drop-down box (cboSupervisor). Once I click on a name in the...

Hi, Is there any way to create a 2 dependent drop-down lists off of one primary drop-down list? I have States, Counties, and Products as the columns. Products are the same across all counties in the same state. I've create a name range linking States and Counties. How do I link up the...

Hi all, I am working on a form that includes product selection through drop-down menus. It starts off with a product category, a chosen category predefines a choice of product names. After choosing a product name, the user needs to select two parameters which both depend on the product name. My...

Good evening, Sheet2 looks like this: | Column A | Column B | Column C | Column D | Column E | Row 1: | Company A | Red | Blue | Green | Yellow | Row 2: | Company B | | Blue | | Yellow | Row 3: | Company C |...

I know how to create a drop-down list and I know how to restrict access but can I do both? I even went so far as to rename the named range to Yes and used Indirect to get the drop-down I wanted but the user can still enter other values when column E is blank. How do I get column G to display a...

Experts: I need your help with creating a conditional name range. Here's what I have thus far. Cells A1:A10 are saved as name range "Customers". I then use that name range...

(Windows 7 ENT, Excel 2016) I have data in a helper table at AB57:AE60. (4x4) for charting in a workbook. The columns are: "Which Data", 2015, 2016, 2017 The rows are: Data 01, Data 02, Data 03 Referencing a drop-down list located at AB2, If AB58:AB60=AB2, express the appropriate row of...

Hi all, I have a VBA problem & no idea how to solve. Sheet 1: Depending on what is selected in the drop-down I'm needing values to show in B4:B11 (Max number of ingredients is 63, but each product has no more than 7 ingredients) & also, values to show in C4:C11. Note - B4:B11 are also...

Hi All I hope one of you can help me with the following. I have in principle the following situation: drop-down cell 01(med with validation): option01-option12 if this shows for example "option01" I did like drop-down cell 02 to show only: option01 and I did like drop-down cell 03 to show...

I'm unsure how difficult/easy to achieve this is, it's certainly beyond my meagre efforts, so any help would be greatly appreciated! I have a series of cells ranging from E5:AT21. Each of these cells allows selection of different phrases via Data Validation List drop-down menus. The options in...

I have a number of cells that have drop-down lists in an estimating document. I have also added a formula to some of these cells to choose a certain option if an item is selected in a different cell. The issue I have is once I have protected the sheet, the cell remains unlocked so the drop-down...

Good Day, I am a first time poster, and I hope i am doing this right :( I have an excel workbook which contains a separate tab with all the drop-down lists, which is used in the all the other tabs. My Brain Boggle: I have City, Province in separate columns (in the drop-down list tab), So if I...

Howdy...Looking for tips to achieve multiple sums. I have a list of criteria along with scores assigned to each criterion, which will be used in drop-down lists in another sheet. <colgroup><col><col><col span="7"></colgroup><tbody> <tbody> Txt 1 for criterion 1 Text 2 for criterion 1...