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...
  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...
  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...
  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...
  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...
  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...
  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...
  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...
  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...

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