drop down

  1. U

    INDIRECT in Data Validation

    I've got three tables TableA: <tbody> List of Tables Other Info TableB Info1 TableC Info2 </tbody> TableB: <tbody> Column A Column B stuff morestuff otherstuff extrastuff </tbody> TableC: <tbody> Column A Column B onestuff redstuff twostuffs bluestuff </tbody> I ultimately...
  2. E

    Using SUMPRODUCT with multiple dropdown menus

    Hi, all! I've got a calendar-style sheet (sheet 3) that I'm pulling data from, and I've got the categories in 2 different dropdown menus on a second sheet (sheet 4). I'm trying to get a cell to add up all of the occurrences of certain text within the calendar. I've figured out how to...
  3. D

    Drop Down List

    Good Day my brave excell'ers! I have a sheet (Sheet2) with the list below [Sheet2] <tbody> a b c 1 Bob obs tech 2 mark nav elec 3 john tac mech </tbody> On [Sheet1] I'd like to have a Drop-Down list in A1, then when a name is selected it populates (B and C) with the relevant...
  4. N

    Hide rows based on drop down list

    Hi MrExcel, I'm fairly new to VBA and macros in Excel and could use more than some help with it! Currently i'm working on creating a report where i have a drop down list of countries (in cell C2) with the list of countries (in column A) and their datas across row A7 to S65. I would love to know...
  5. T

    Conditional formatting to highlight duplicates with enabled/disabled drop down list

    Hello everyone, I have a file with projects' staffings. Some of the workers assigned to these projects are temporary employees, some of them are permanent ones and some of them are leads. I would like to create a conditional formatting rule that highlights the permanent, associate leads and...
  6. A

    (3) Dropdown list to equal $

    Greetings, is it possible to have (3) dropdown lists equal a dollar amount? Task at Hand: I will try to simplify to help make sense. Let's use a restaurant menu as an example. Depending on your order and the options chosen, the total will be different. Dropdown list 1: Types of meat-Chicken or...
  7. A

    Auto correct name spelling from a reference list

    Hii, I am trying to create a sheet that would track samples distribution to customers. In the attached sheet under the Tracking Sheet tab I've set the "HCP" column to be a drop down menu to avoid miss spelling names. I want to avoid miss spelling names so the pivot table would be accurate...
  8. J

    I'm trying to copy a column based on my drop down box

    Hello, I am trying to copy a column from Worksheet 2 to Worksheet 1 based on my drop down box on worksheet 1 which is made up of the column headers on worksheet 2. My drop down box is on worksheet "Drawing Content" in cell B1 and the column headers are on worksheet "Master" and start in E1 and...
  9. G

    Select and Entire Column for a VBA Multi-selection dropdown/Expand cut and paste option

    I had reached out previously about getting a code so that based on a selection in row A if it were to be switched to completed that the entire row would be cut and then put into the Completed tab. I wanted to see if I could get this code edited so that the same option for when it is completed...
  10. 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...
  11. A

    Using VBA to select a new drop down list for each new drop down

    Hey guys, I'm running into the issue where I would like to create a drop down in each cell in the range h4:h74, and for each drop down, have each drop down reference a new data set from B86:BT86. So for cell H4, the drop down in that cell should reference B86:some ending point, H5 should...
  12. N

    Blank values accepted in a list validated field

    I have a named range without blanks in it. I have configured cells in a column to be validated against this list. If I type in a value that is not in the list and tab out of it, I get the expected error message, but if I leave the cell blank I get no error at all when leaving the cell. I have...
  13. K

    Website not updating after inserting drop down option via VBA

    I've tired a lot of different approaches and still have not figured out any way to overcome the issue. When use the .selectedindex = 10, the option appears just like i wont it to, but the date range boxes will not appear after i've picked the option. ive tired .focus .fireevents .click and many...
  14. D

    Drop down Vlookup to display embedded image in fixed location (via mouse rollover)

    I've been reading up on a solution to this mouse rollover problem. I've found bits of the solution on various sites, but nothing that ties my needs together. Basically, I have a drop-down list of various exercises on Sheet1. Upon hovering over the selected exercise (ie. squat), I need a VLookup...
  15. D

    SUMPRODUCT - Summary Sheet Drop-Down Menus

    Hi there, I have two sheets on a workbook - a summary table and a master record table. For each record on my master table, I want to add it to a count on my summary sheet (see below). <tbody> Summary Table Jan Feb Mar Apr May Name 1 0 0 0 0 0 Name 2 0 0 0 0 0 Name 3 1 1 0 0 0 Name 4...
  16. J

    Data validation lists - delete cell and show value, not a blank

    Hello! How can I set a data validation list such that if the drop down value in the cell is deleted, the cell will automatically show a default value (i.e. "-Select-")? For example, I have a worksheet with multiple drop down lists that I want to show a default value of "-Select-" once the...
  17. G

    VBA- Clear Dropdown List and Start in 1st Postion

    Hi All you Guru's, I need a little help. I have 5 Dependent drop down Lists. Created from the Data Validation. I would like to reset the selections once the user decides to do another selection. I created this code below. The idea is the if the user makes the 5 selections and if he chooses to...
  18. J

    Dependent drop down from table?

    Hi everyone. I have a bunch of information in a single table. I want to use 2 drop-downs and then a Vlookup with indirect function to call that data out on another part of the sheet. Everything that I've seen so far shows making dependent lookups based on making multiple tables. I can't do...
  19. F

    Grouping Values for a Macro?

    I'm beginning to learn to code in Excel, and I have a question about grouping items. I have about 100 different "types" of items that are separated into about 5 groups based on how I describe the item. I created a user form that allows you to choose the item from a tiered drop down list and...
  20. T

    From Drop Down lookup partial values

    I have a Drop Down. Assume I select "Varia Single 25/2,3 90" Now I want to return other values where either 25/2,3 or 90 are included. I want the whole value to be returned. List <colgroup><col></colgroup><tbody> Pexflextra 25/2,3 90 <tbody> Uno 25/2,3 76 <tbody> MX-Radiflex 40/3,7...

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