drop down box

  1. C

    Formula Based on Result of Drop Down Box

    Morning All, I am after a little help with a formula this morning to determine a specific date. On my Spreadsheet In cell E2 there is a dropdown box which contains a number of financial years in the format yyyy/yyyy. The actual data is held on another spreadsheet. What I would like to do is...
  2. S

    Time Stamp with initials from dropdown box value

    Currently I have an Excel file which enters a time stamp depending on if a value is entered in Column A. So it looks like this <tbody> Column A Column B Column C Data<where value="" is="" entered<<="" td=""></where> Blank<blank for="" now=""></blank> A Date Stamp auto fills when something...
  3. F

    How to autofill multiple drop-down lists?

    Hi all, I have a long list (several hundred rows) and I am trying to create drop-down lists that each contain about 5-6 options of my list. I'm sure this can be done with VBA but is this possible to do with basic Excel functions? For instance, drop-down list contains cells A2:A5, drop-down...
  4. C

    hide and unhide rows based the selections in my dropdown list. Please help

    I am hoping someone can help me. I am creating a form in excel using the active x combo drop down option. I am trying to hide rows based on the option they pick. I added the active combo box in cell B3 with options A, B, and C. Based on what they pick I need the following to happen... If...
  5. M

    Variable Drop Down List

    Hello, I am looking to create a variable drop down list that shows the products sold based off of a customer that is selected. For example, if I select customer A, I want the drop down list to show products A, B, C and D that are sold to that customer. However, when I select customer B I only...
  6. A

    Drop down list and data copying to another sheet based on selection.

    Hi every one, I need something that is quite complex and so I'm trying to explain it the best I can, apologies for any ambiguity. So, I'm setting up a tracker for the work done on clients by employees and similarly the work that the employees have done, I need to be able to see both at a...
  7. M

    Format Colour in Drop Down menu?

    Hello there, I'm wondering if Excel's drop down menu allows you to format the color of the options provided in the drop down box. I am essentially trying to make three symbols appear in the drop down: a bold red up arrow, a bold green down arrow, and a bold orange em dash. I have these...
  8. N

    Multiple Selection on a dependent / cascading drop down list

    Hello all, I am trying to put together a sign-off sheet of responsibilities within my organization. To do so, I've created two cascading drop-down lists via Data Validation: Independent Drop-Down: Department within the organization Dependent Drop-Down: Position in the corresponding department...
  9. S

    Drop down list question

    I have 2 drop down lists in A1 and B1, both with a “Yes” or “No” selection. How can I make A1 change to “Yes” automatically if B1 is set to “Yes”? I can’t use macros, only formulas, etc.
  10. C

    Change cell value based on drop down menu

    Hello Everyone, So I created a drop down menu with the days of the week on it. Now I want to be able to alter a cells data to read a time per each day. =IF(K21="Friday","4:00pm") This formula works and hypothetically I should just be able to repeat this a bunch of times but for some reason...
  11. V

    Populate form control Drop Down Box with unique value

    hi, I am trying to populate a drop down box with a column of dates and only want to populate unique values. I have tried the following code but it doesn't work. Can anyone please assist? Sub FilterUniqueData() Dim Lrow As Long, test As New Collection Dim Value As Variant, temp() As...
  12. P

    Replace value picked in dropdown box, from a table data

    Hello! So I am facing a problem with an excel problematic for my work I can't figure out on my own, even after researching a lot online (or when I try them they don't work). I have attacher the file if it helps: https://we.tl/7hopolpjUV. So I would like to replace à value in a cell by a...
  13. S

    VBA drop down / radio button / function to select ....

    So, I am looking for a something simple. I need to call a macro that displays a window with some options that I will pre-define, for me to select. The selection needs to be stored in a variable which I can then use later in the macro for other purposes. The issue I am having is that I can't...
  14. N

    Creating multiple worksheets with data validation based on a single master worksheet

    Hello everyone its been a while since I asked for help but I am trying to create a dynamic list, maybe I should use a table, on one worksheet (something that can grow or shrink in # of rows over time) and have that dynamic list available on several other worksheets in dropdowns so that when an...
  15. C

    Drop down lists and pulling data from worksheet based on drop down selection

    Hello MrExcel community! I am in need of some assistance. I am trying to implement a new staff directory for Special Education staff assigned to schools for the very large school district I am employed by. I have created a data worksheet (Master) with all 180 schools and up to 13 staff...
  16. A

    VBA Help

    I have created a file which is having a drop down list of names vlookup on Sheet1 with another sheet. Hence, one name is selected the values will be displayed on the Sheet1 as vlookup arranged. I need a VBA for that dropdown list having cell (B4), Hence it should be split into multiple...
  17. N

    Excel drop down selections x2 with outcome in third box.

    Hi, I have put together a table with roof pitch (0.5-30 deg) along the top and roof area (5-800m2) down the side, these are my two variables that I would like to select in two separate drop down menus. Based on the selection of roof pitch and roof area selected in these two drop down menus, I...
  18. L

    Worksheet print from a dropdown list

    My problem is coding a drop-down list that selects the worksheet that needs to be printed. The worksheet information to be printed reside in the column "C". In this example, I am showing the dropdown the "vv" selection and I am printing the "sheet1". I see that the formatting is not working in...
  19. E

    Excel: How to create a drop down list that pulls up all the data associated with the selection made?

    I am trying to create a master sheet where all the information associated with each name is entered. It is in a table and each name is repeated in 4 rows and then it goes to the next name and so on. Each name has 4 (1,2,3,4) different ID#'s that indicates the depth where the sample was taken. I...
  20. G

    Unable to remove drop down box

    Hi I have an Excel (2016, O365) sheet with a blank drop down box that I just can't delete. I have tried all the suggestions listed on this forum and others but the drop down box still remains. They appear in the selection box, but above a black line. Are items listed above the black line...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top