drop down list excel

  1. D

    VBA selected drop down list does not update when source changes

    Hi! First time poster;) I have a two-tab budget. First tab is “Monthly Budget”, the second is “Spending Tracker”. Every time I add an expense in the “Spending Tracker”, it updates the “Monthly Budget”. I do this by selecting a category from the drop down list on the “Spending Tracker”. I want...
  2. 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...
  3. 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...
  4. 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 ---
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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?
  11. 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()...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back