drop-down list

  1. L

    Conditional drop-down list

    Hi all, Vers office 365 (with xlookup) I am already going to implement the formula from this thread Drop Down lists but I am struggling on some mechanics of my drop-down list as I have many conditions. I want the drop-down list journey to be: Internal/External? -> Provider name -> Target...
  2. D

    Auto Refresh the Drop-Down List in Excel Worksheet

    Hello Everybody, First of all, thank you so much for using your time in assisting me with this matter and reading this inquiry. It is greatly appreciated! I am currently making an order form in Excel, where I am pulling my product data (material description) from a sheet I have named...
    • David77
    • Thread
    • automatic adjustment drop-down list excel list offset
    • Replies: 9
    • Forum: Excel Questions
  3. N

    Data Validation and Auto Fills

    I have a spreadsheet I'm working on where I need to track daily sales, that connects with a commission structure. The current table I have shows all days of the month (29 days this month), I have created a Data Validation drop-down list with other months of this year. Is there a way, that when...
  4. L

    Drop-down list with index(match

    Hey guys, has the website had an upgrade? Looks great! I'm trying to make a waste cost dashboard. Basically, all I want to do is select the supplier code from the drop-down list and once I enter the number of workshops run, it will automatically update the number of seats the event had space...
  5. R

    Flexible and conditional drop-down list

    Hi everyone, I am working for a project for my company and would need some help on an issue I have. Ultimately, I want to create a model that is as flexible as a PivotTable without using a PivotTable. The reason for this that I won't be able to change any fields. I am working with...
  6. K

    Need Fertilization for summery sheet

    Dear Experts, I have a datasheet and i want result in second sheet based on week numbers. Main columns are as i mentioned below, Customers Styles Qty Rate Values shipment dates week numbers (Weeknum) status (In-process, ready to ship, shipped) in second sheet using same columns and i want...
    • Kamran01
    • Thread
    • conditions conditions to a criteria drop-down list filter lookup
    • Replies: 0
    • Forum: Excel Questions
  7. L

    Change text color in cells IF text in ANOTHER cell equals 'Goods In' etc

    I have a table with 6 columns. The first column is a drop-down list with 5 options indicating whether a row is Stock IN or Stock OUT. I need the rest of the corresponding row to change text color depending on the value in the drop-down list. For example:- IF Cell A1 is equal to "Own Haulier In"...
  8. P

    ClearContent for drop-down fields

    Hi, I havecreated a template for my staff to use. I've written code that generates aunique sequence number and saves the file but I am having trouble when it comesto removing any information that may have been pre-existing on the form. I amcurrently using the ClearContents command but I've found...
    • PhilMc
    • Thread
    • clearcontents drop-down drop-down list fields
    • Replies: 1
    • Forum: Excel Questions
  9. J

    VBA code to populate a cell if a certain item is selected in another drop-down list; push this to 1400 rows

    I recently created a private module that when "alcohol" is selected in cell Q3, then the text string "No nutritional value" is automatically entered into cell U3, and the text string "Over21/single" is entered into cell AA3. If "alcohol" is NOT selected in Q3, then U3 and AA3 have a drop-down...
  10. J

    How to select a certain item in a drop-down list using VBA?

    If I select a certain item in a drop-down list, is there a way to populate a certain item in another cell that has a drop-down list?For instance, let's say I have a drop down list in A1 which lists RED, GREEN, BLUE. If I select RED in A1, if B1 has a drop-down list which lists 1,2,3, can I have...
  11. J

    If "red" from a drop-down list in A1, then "certain text" in B1, else a drop-down list in B1. How?

    If "red" from a drop-down list in A1, then "certain text" in B1, else a drop-down list in B1. How can I do this with VBA? I want to create a drop-down list in, say A1, which returns RED, GREEN, or BLUE. If a user selects, say RED in the drop-down list in A1, then I want another text string to...
    • jkalpus
    • Thread
    • data validation drop-down drop-down list list red
    • Replies: 3
    • Forum: Excel Questions
  12. 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...
    • Kaoutar
    • Thread
    • dependent drop-down drop-down list indirect product
    • Replies: 1
    • Forum: Excel Questions
  13. M

    Saving Data in a Range of Cells Dependent in Selection from Drop Down List

    Hi, I am looking to combine a drop-down list with a range of editable data that can then be saved and later loaded (if possible). What I mean exactly by this is to first have a single drop down list containing all of the calendar months of the year. A range of data (dates, vendors, costs, and...
  14. J

    Data validation drop-down list

    I created a drop-down list with different fruit names and I want the user to be able to type in the first couple letters of the fruit name and have it auto-populate. For example, if the user types in "ap", the word apple would automatically appear. Is there a setting within the data validation...
    • jgeorg0310
    • Thread
    • auto popluate data data validation data validation list drop-down list
    • Replies: 1
    • Forum: Excel Questions
  15. A

    Vlookup overriding a drop-down list

    I have a drop-down list in both cells A1 and A2 each with different values. I am trying to let a vlookup override the drop-down list in A2. For example when you select 'Leave' in A1, A2 must automatically choose a specific value from the drop-down list in A2 that cannot be changed. I tried a...
    • Alenz
    • Thread
    • dependent drop-down drop-down drop-down list vlookup override
    • Replies: 1
    • Forum: Excel Questions
  16. I

    Dependent drop-down lists in a table range

    Hello guys, I am trying to create a dependent drop-down list in a table range that is dependent on what the user chooses in the first column. The data for the drop down lists are stored in another table on another sheet. Imagine that the table below is formatted as a table range (Formatted as...
  17. C

    VBA Copy-Paste based on Drop-Down menu selection in seperate worksheeet

    I'm just learning to improve my VBA skills. Made lots of progress yesterday but now I find myself faced with a momentary wall... My dilema: I have two sets of data in Sheet2: one set in array AT1:BU2000 and the second in array AB1:AR2000. There is a drop-down menu in Sheet 1 containing a list...
  18. D

    Automatically select a response from a drop-down list

    Hello! I have an online satisfaction survey that I give out to customers. Each month I export the responses from the software as an excel file. However, I also have a separate excel file that is used for tracking purposes. I have been manually inputting the data into the tracking spreadsheet...
  19. A

    Formula in dropdown list

    Hello, I am trying to create a drop-down list based on a (rather complicated) formula, and since the validation rule won't accept a formula, I'm not sure how to proceed. Essentially, I am trying to create a spreadsheet for scheduling staff in various locations, based on their qualifications and...
    • aestable
    • Thread
    • drop-down list index & match schedule chart validation
    • Replies: 10
    • Forum: Excel Questions
  20. L

    Appending string value in cell with new unique selection from its drop-down list

    Hi, I'm very new to VBA programming and I'm not yet able to put together a macro I need :eeek:. I'm not quite sure even where to get started. I'd like to create VBA Macro that allows a blank cell to be set a value via its drop-down list then take each subsequent value selected via the same...
    • logicalchoice
    • Thread
    • append new string values drop-down list macro update drop-down list vba
    • Replies: 0
    • Forum: Excel Questions
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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