dropdown box

  1. K

    Hide Tabs Based on the Choice of Multiple Items from Drop Down List

    Hello, I have a question regarding how to hide multiple sheets based on a user's selection from a drop down list. My spreadsheet has around 60 tabs (the sample only shows 30) and only 15-30 of these will be in use for a project. I would like the user to be able to use the drop down list to...
  2. B

    VBA Code to Search and produce results based on the criteria

    Hi, Can someone help me with the below requirement. I have data as below in the sheet1 of workbook1. Team RegionEmployee NameCurrent ManagerTS/GS26-Jul27-Jul28-Jul29-Jul30-Jul31-Jul01-Aug02-Aug03-Aug04-Aug05-Aug06-Aug07-Aug08-Aug09-Aug10-Aug11-Aug12-Aug13-AugCXYrYvYnYn XhYnmugYmCHYrXh...
  3. M

    Vlookup in Excel VBA for Data Entry

    HI Excel Expert , Request your valuable help in solving the below error . PS: Am new to Excel VBA coding . I have got 3 Sheets in the attached workbook “Just combo V2” Download link : Just combo V2.xlsm Sheet 1 Sheet 2 =”School” in which Cell A1 : A14 Contains list of schools Sheet 3...
  4. A

    Check Box in Drop down list

    Hi all, I'm in need of a Check Box in Drop down list for multiple selection. The code which i had is given below. The disadvantages of the given code was duplication and unable to edit the selection. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As...
  5. C

    How to search on numbers via dropdown box to return results in subform

    I've created the query on InvoiceID which is a large number. I have already created the search drop down box showing numbers in order. However when I select the number the Subform blanks out (there is data) rather than showing the results of the InvoiceId. I have used this code on other...
  6. C

    split worksheets based on dropdown

    Good morning, I have a report with 500 separate account results - these are currently set up as a self serve via a dropdown. What I want to do is create 500 separate split worksheets based on the dropdown choice. However I want each worksheet to display all the results /charts etc which are set...
  7. M

    How to reference a data validation answer in a cell in another sheet

    Hi, I am recieving a #VALUE ! error when trying to copy the result of a data validation drop down in another sheet and dont know why. e.g. In sheet 1 I have a a drop down box in a cell (A1) that has recent dates in. On sheet 2 I want the chosen date to show in a cell. I have put the formula...
  8. S

    Message to user of which to select in 3 different drop downs.

    Hello, I'm currently working on trying to have a warning box that indicated when the drop downs have not been selected, but I'm coming back with too many formulas for this one box. Currently I have: =IF(AND(B4="Choose Current Grade", B6="Choose Proposed Grade", B8="Select Geographic...
  9. A

    Dropdown list for the Item listed in the PivotTable Field List ?

    Hello everyone, I am almost done with a large dashboard for my company, and I feel a little lost on this final touch I want to add to it. I do not know how to attach a pic, but i will try to explain in a way that makes sense. In my Pivot table worksheet, i can get a slicer and be able to...
  10. D

    Seeking Cool Drop Down Box Design

    To Excel Giants Everywhere - Please help, I am familiar with the general options for drop down lists... i.e. format the cell to reference a list and then check one. Is there another solution where a user can check multiple options and then those options are stored in one cell? If so, is...
  11. M

    Drop down to generate list from table

    Hi I am looking to generate a list from a drop-down menu. On sheet 1 there is a table which lists “keywords” in column A and “policies” in row 1. Within the table “x” is marked where a keyword is found in a policy.</SPAN> On sheet 2 I have a drop down list with all the keywords and what I...
  12. B

    Code to find value based on dropdown selection

    Hope someone can help... I have a dropdown list of employee names to filter a matrix-style spreadsheet. On selection, all columns except the selected are hidden. My problem is that every time I add a new employee, I have to modify the code to match the name to a specific column. I need code...
  13. P

    Drop down boxes

    Hi All I have a list of industries which I would like to have as a drop down box, to restrict only the industries included in the list. I'm not sure how to do this. Any help please. Many thanks :confused:
  14. J

    Create table based off drop down box selection

    Hey All, Im trying to create a table based off values in another reference worksheet which will be generated from a value selected from a drop down box. The values in this newly generated table is then to have a dropdown box next to them in which W or L can be selected. the link below...
  15. W

    Using dropdown box to change data in spreadsheet

    I have a dropdown box which I want to use to populate data into about 10 different cells on the top of a spreadsheet. There is a lot more data on the spreadsheet that I do not want to change with the dropdown box, this data will also feed into other sheets in the workbook.
  16. B

    Checklist/Dropdown - Screenshot included!!

    Hi, I am researching companies and tracking my research using an excel spreadsheet. I've created a rubric rating a company 1-5 with 5 being the highest rated/i.e. best potential sale. Each of the following items is rewarded with one point for each of the following. 1. High need of paper...
  17. D

    Using two data validation lists to select element in array

    I am trying to use two seperate dropdown lists to select a specific value in a table of set values. The first drop down will select the row and the second will select one of two columns. I have the data validation lists ready to go but it looks like the main hangup I'm getting is having the...
  18. L

    How to automate data entry in a cell using Drop down menus ?

    Hello, Is it possible that selecting an item from drop down should enter certain text in a cell ? For example in cell "L7" there is a drop down with two items 1) pay due 2) Bill Selecting (pay due) should enter following text "Payments are due from the dealer, requires special attention."...
  19. S

    Autofill Drop Down Box

    Hi This is my first post. I'm wanting to know if there is a way to auto fill a drop down box. For example I have a drop down box in Cell A1 which has an input range of $E$1:$E$4 and a cell link to Cell A1. I now want to have another drop down box in Cell A2 with the same input range and but...
  20. F

    IF functions and drop down boxes

    Good morning Mr Excel, I am trying to create a formula that allows me to have different options populate a cell depending on the content of another cell. I think i have done this before but cant remember the finer points, =IF($C$7="Select Axle...

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
Top