drop down list excel

  1. R

    Vlookup to show drop down list as per Heading selection

    Hi Excel Experts, I am currently working on Excel sheet in order to show drop down list as per heading selection with no blank in drop down list. Please suggest how can i show use drop down list through vlookup or other nested formulas in worksheet. For Example: Fruits (Heading) Apple...
  2. M

    multi item drop down items and non-multi item drop down lists on the same page

    I have multiple cells with drop down lists created using data validation. I would like some of them to have a multi item option and some to be single item choice. The VBA code I am using is applicable to an entire sheet and makes all of the drop downs multi item. Is there a way to specify...
  3. J

    Client Form (Example Image Included)

    I below linked document was originally created in Excel and I added to Google Docs, so I could provide the document for review. https://docs.google.com/spreadsheets/d/1d4zZxBRgSvpN2nsCTJhNO6jdAgSYymBgW8BbkMHydI0/edit?usp=sharing Picture: -- removed inline image ---
  4. D

    How to change date from numbers to words drop down menus

    Hi everyone i am a bit of a novice so sorry if this is easy. I have a group of numbers in a table of spreadsheet. 1. $100 2. $200 3. $300 In the drop-down list in the spreadsheet instead of showing $100, $200, $300 i would like it to say Bronze Silver and Gold. Obviously i still need the...
  5. O

    Creating a dropdown list using OFFSET

    Hi, I've been trying to create a drop down list using the following formula where PROJECTLIST = LISTS!$G$2:$G$71 or G:G (I have tried both) If I just use the PROJECTLIST array for the drop down list it shows everything, if I use the formula below it only returns 47 entries - is there a limit to...
  6. B

    Dropdown menu cell connection help!

    Hi everyone, I have one worksheet that tracks data from other worksheets in excel. The first worksheet is used as a summary of what's going on in the other worksheets. I am trying to connect a cell in the first worksheet to a cell in another worksheet but the cell in the other worksheet...
  7. E

    Creating a Dependent DropList from same List Source (One to One) based on dates

    Is it possible to create a dependent drop list from one source of data? How do I limit selections choice by date constraints? In addition, it filters out the date selection from the first choice and the user can not pick a date going backwards? Creating a market model for senior execs and BOD...
  8. J

    Sum of drop down selections(text) among pages

    Hello, I appreciate any help I can receive on this. 1-I have a drop down list of text. How do I add a numerical value of '1' in order to then sum drop down selections? (if this is a necessary first step) Currently the list starts in A1 and continues down in the A column on a separate page...
  9. N

    Drop Down Selection

    I'm having an issue trying to create a drop down selection for an excel based form. I was hoping to create a drop down list without needing to reference cells; eg. What's your favourite colour? | RedBlue Green Is this possible?
  10. S

    Excel cannot read user input through drop-down list as a Hijri date!

    Respected Members, First of all, I want to thank everyone contributed to this forum. So much I learned for you! Hope you can help me on below issue I searched on the net and here in the forum and found several suggested solutions. Yet, none of it worked for me! When I use function today()...
  11. T

    table w/ drop down lists and multiple formulas

    I have a table with 5 columns and each row is a option A, option B, option C and so on. Each column is a different category with a drop down list of options to choose from. column 6 I want to auto populate an entry based on what is selected in each drop down list in the first 5 columns. I am not...
  12. L

    Fantasy football VB code using drop down list

    Hello, i am working a side project try to organize football stats. i have a drop down list that consists of 12 positions and i have 12 work sheets, each one being a different position. i am trying to get it so that when i would choose a position from the drop and maybe click a "retrieve...
  13. C

    excel 2010 dropdown list to remove

    Hello, I am working in excel 2010 and I would like to create a combobox (list) using the developper ribbon that leverages a list of dates from another tab. I created the combo box and used a named range as the source of dates but I cannot see a way to select unique values only. Is there a...
  14. Z

    VBA: select column through 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...
  15. Z

    VBA: Choose with drop down list column A or B to calculate

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

    Creating Multiple Dropdowns

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

    Removing blanks from a drop down

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

    Drop down list help

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

    Dynamic drop down list, how to do?

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

    Using Excel Macro to Create a Drop Down List and Hide Cells

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top