drop-down

  1. M

    Using a drop-down to populate the next 10 columns with pre-set values

    Hi guys, I want to create a 2-item drop-down such that when you select each item it will populate the following 11 columns with pre-set values related to that item. Here's the sheet as it stands, which we've been populating manually by copying and pasting... I want to make the "TX...
  2. E

    Filtering not showing all the data

    Hi there, I'm working in excel 2016 and have a simple spreadsheet with rows and rows of data and have filters on all columns. I noticed that the drop-down box on any of the columns does not list all the data. I have removed blank rows, however the drop-down on the filter is still limited. Can I...
  3. E

    Increasing the size of the drop-down box

    Hi there, I am working in excel 2016 and wondered is it possible to increase the size of the drop-down box to match the size of the list in the box or even to make it bigger than it already defaults to? Or is it a pre-set size and can be adjsuted? Any assistance would help and save me...
  4. M

    VBA to hide and unhide rows in Excel based on a value

    Hello all, I've been finding past forum threads useful to learn from others' experiences as I get the hang of Excel. Maybe someone can help me with a question of my own? I have a drop-down list in A3 of my Excel spreadsheet (version 2010). I'd like my user to be able to select an option from...
  5. N

    Drop-down list from Data Validation List keeps moving to the bottom, any way to make it stay on the top?

    I have a data validation list for every cell in a column. The source for the data validation is dynamic, so that whenever you choose one parameter from the validation list, it gets removed from the source list. Because of this, when I go to a second cell and click on the drop-down menu, it...
  6. C

    General help with an excel service schedule

    Hey All, I'm creating a service schedule. The schedule would have a list of service engineers and show what customer's they are at throughout the year. The whole year with days of the week and dates would be on one sheet. On the far left most column from top to bottom, I have the year which is...
  7. B

    New to Excel VBA

    Hello everyone! I have been asked to take a stab at creating a small GUI to look up data vs. Filtering data in excel. The reason I am doing it this way is because I will be summing totals as I click on certain people. I created a drop-down box (cboSupervisor). Once I click on a name in the...
  8. V

    Multiple Drop Down lists off of one primary drop down list

    Hi, Is there any way to create a 2 dependent drop-down lists off of one primary drop-down list? I have States, Counties, and Products as the columns. Products are the same across all counties in the same state. I've create a name range linking States and Counties. How do I link up the...
  9. K

    Dependent Drop Down

    Hi all, I am working on a form that includes product selection through drop-down menus. It starts off with a product category, a chosen category predefines a choice of product names. After choosing a product name, the user needs to select two parameters which both depend on the product name. My...
  10. M

    How to populate a drop-down list based on column value

    Good evening, Sheet2 looks like this: | Column A | Column B | Column C | Column D | Column E | Row 1: | Company A | Red | Blue | Green | Yellow | Row 2: | Company B | | Blue | | Yellow | Row 3: | Company C |...
  11. U

    Data Validation list in column G is Yes in column E and restrict entery if E is not Yes

    I know how to create a drop-down list and I know how to restrict access but can I do both? I even went so far as to rename the named range to Yes and used Indirect to get the drop-down I wanted but the user can still enter other values when column E is blank. How do I get column G to display a...
  12. S

    Conditiional drop-down (based on > than value)

    Experts: I need your help with creating a conditional name range. Here's what I have thus far. Cells A1:A10 are saved as name range "Customers". I then use that name range...
  13. D

    IF or should I use another function?

    (Windows 7 ENT, Excel 2016) I have data in a helper table at AB57:AE60. (4x4) for charting in a workbook. The columns are: "Which Data", 2015, 2016, 2017 The rows are: Data 01, Data 02, Data 03 Referencing a drop-down list located at AB2, If AB58:AB60=AB2, express the appropriate row of...
  14. B

    VBA to lookup and show values

    Hi all, I have a VBA problem & no idea how to solve. Sheet 1: Depending on what is selected in the drop-down I'm needing values to show in B4:B11 (Max number of ingredients is 63, but each product has no more than 7 ingredients) & also, values to show in C4:C11. Note - B4:B11 are also...
  15. J

    Drop-down (with validation) relate to content of multiple other drop-down menues

    Hi All I hope one of you can help me with the following. I have in principle the following situation: drop-down cell 01(med with validation): option01-option12 if this shows for example "option01" I did like drop-down cell 02 to show only: option01 and I did like drop-down cell 03 to show...
  16. W

    Warning pop-up message from specific values chosen via drop-down list

    I'm unsure how difficult/easy to achieve this is, it's certainly beyond my meagre efforts, so any help would be greatly appreciated! I have a series of cells ranging from E5:AT21. Each of these cells allows selection of different phrases via Data Validation List drop-down menus. The options in...
  17. S

    Protecting a formula in a cell that also contains a drop-down list

    I have a number of cells that have drop-down lists in an estimating document. I have also added a formula to some of these cells to choose a certain option if an item is selected in a different cell. The issue I have is once I have protected the sheet, the cell remains unlocked so the drop-down...
  18. M

    Cell to return value depending on item chosen from dropdown list

    Good Day, I am a first time poster, and I hope i am doing this right :( I have an excel workbook which contains a separate tab with all the drop-down lists, which is used in the all the other tabs. My Brain Boggle: I have City, Province in separate columns (in the drop-down list tab), So if I...
  19. E

    Multiple tabulation

    Howdy...Looking for tips to achieve multiple sums. I have a list of criteria along with scores assigned to each criterion, which will be used in drop-down lists in another sheet. <colgroup><col><col><col span="7"></colgroup><tbody> <tbody> Txt 1 for criterion 1 Text 2 for criterion 1...
  20. A

    Cascading drop-down data validation lists with only unique items.

    Here is a gross over-simplification of my dataset in Excel (it's larger and more purposeful than this). It's in a table, at this point with quite a few more columns and vastly more rows. <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...

Some videos you may like

This Week's Hot Topics

Top