drop down list excel

Hello, I would like to select data from 2 different columns in Excel, depending on the column selection in a drop down list (e.g. column A or B) defined in another named cell (e.g. Listcell). So I select the column from that list and then will make calculations on the chosen column. Can you...

Hello, I have 2 columns with a variable number of rows in Excel. With VBA I want to perform a calculation on either column A or B. I make that selection through another specific cell where I define a drop-down list with titles of each column to choose from. Through the selection of a column in...

Hi, I've encountered a very frustrating situation after conquering what I thought had been the hard part of my project. I spent a good part of today looking around on Google and this forum in search of a solution without having any success, so I'm hoping someone can give me a hand! What I'm...

Hi guys :) I've inserted a drop down list in my spreadsheet, and I am getting (as well as the information I desire), blanks when I click the drop down, does anyone know how to remove these blanks? It is imperative that I do not remove the cells highlighted in the range. Thank you in advance...

Hi there, new to this forum so sorry if this thread goes against any guidelines or anything :p I am creating a spreadsheet system for storing student grade data, and I need to be able to select from a list of 240 students, who are all in different year groups, then form groups (e.g. 7a), then...

Sheet 1 ColA ColB 1 AnsA 3 AnsR 1 AnsF 1 AnsS 2 AnsD Sheet 2 - Should have drop down ColC - should have unique list from Sheet1!ColA. for eg. 1,3,2 ColD - list should be based on selection in ColC. For eg., if I select 1 in ColC, This should...

I am having trouble with a macro that is supposed to perform the following tasks: Prompt the user to input a cell where the drop down list is to be located Prompt the user for a range of data to use in the drop down list values Create drop down list Hide the rows in which the drop down list...

Good afternoon... I am sure this question has been asked many times, and I thought I saw one of the Mr. Excel or ExcelisFun videos on YouTube which discussed this topic, but I cannot find it. I want to create a drop-down list that consolidates repeated data only once. Then create a second...

Dear all I am just preparing Update tracker for my personal use (with version 2007). I have created drop down list with few categories in first page or worksheet. and gave the category name to each and every worksheet. For example: if i have category called "ABC" in drop down list and there...

Hi there Hoping someone can help me out. Is there a way to select multiple items from a drop down list into one output cell in Excel? Thanks.

Hi All, Quick question; I know that with the ALT+Down Arrow you can open a drop-down list, and by hitting the first letter of the entry you're looking for you'll navigate easily to that entry. But what if you've got loads of entries starting with the same letter; is it possible somehow to...

I have a list of 6 people who play games against each other. At the end of all the games i need to be able to provide a drop down menu if 2 or more people have the same points, goals for, goals against. Can text cells be automatically entered into a drop down menu on a separate part of the...

I've got some drop down lists on a worksheet. The lists use named ranges to get their data from and you can fire different macros using the drop downs. When I fire a macro or activate the sheet, all the drop down list seem to flicker/flash for a second or so (I guess they're populating the...

I am looking to use excel as a scheduling tool with the use of drop down boxes. What I need is a drop down box that picks from a list, and once a selection is made, that selection is no longer available to the other drop down boxes. For example, let's say I have three people: Bill, John, Sue...