1. L

    Excel Dependent Drop Down Error

    I am creating a dependent drop down where the drop down itself is located on the first tab of the sheet and the data that includes the dropdown options is on another tab. When the drop down and the data are on different tabs, I get the following error when entering the index match function into...
  2. A

    writable cells limited by dropdown

    I am in Excel v2016 on Win11... I am preparing a book catalog for my simple purpose of data entry, that is entry of bibliographic metadata (the usual title, author, etc.). I have 9 column fields named with an alphanumeric 'code', a simple combination of a number (1-9) and 2 lowercase letters...
  3. J

    Excluding a Cell range from a selection in a drop down list

    Hi All, I currently have a budget sheet where when i select a customer from a drop down list, the ratio will calculate and change the result to show the overall profit as per selected customer. The client was created by a data validation list and the ratio through a xlookup. The ratio in...
  4. N

    Change Dropdown selection in one dropdown after the selection in an other dropdown has been changed

    Hello, so first of all - this is not about dependent dropdown lists - The dropdown lists in my excel file are already dependent from each other. What I would like to know if it's possible to automatically change what is set in one dropdown when changing something in an other one. So for...
  5. D

    Populate dropdown list of values from table based on cell value

    Hello, I've searched this forum and many examples on google of a formula or data validation list formula that might accomplish my needs to no avail. I'm looking to populate a dropdown box's list of values from a table on another sheet that matches a cell value. I've seen many examples of the...
  6. T

    Rule for Dropdown > If the selected user already posted the value to database, then do not show in dropdown

    Hi, I am a total beginner in VBA. I have an excel with two sheets as "form" and "database" (actually more but others are not relevant). In the Form; 1) Users type their username, password, and select the week. 2) In the orange part, users type other stuff (to all 3 rows). 3) When submitted...
  7. T

    VBA - INDEXMATCH for a Worksheet Change Event or another approach by not showing already selected items in dropdown

    Hi, I have an excel with two sheets as "form" and "database". In the form sheet, various users type their input into rows 9-12, and before posting each user selects his/her username, type password, and select week in Cell F7 (which is a dropdown where options are Week 1, Week 2, Week 3, etc.)...
  8. P

    Add a dependent dropdown on UserForm with list constantly changing

    Hi, I have a spreadsheet containing a list of products and Promotions. Each product can have multiple promotions, and one promotion can be found in different products (many-to-many). This spreadsheet is updated constantly. I created a UserForm with a dropdown list containing unique products...
  9. A

    Editing Auto-populated Text

    Hi! I've just been Googling excel forums trying to find a way to do this. I just want to make a cell auto-populate a body of text based on a dropdown menu selection. I know how to do that, though... However, I want to be able to EDIT the text that populates...and I DON'T know how to do that...
  10. C

    Running VBA Code from Excel to delete a Rich Text Format from a Word Document Dependent on A Dropdown Box in Excel

    Hi all, I am working on a project that uses a form I have created in Excel to populate Rich Text Formats in a word document in order to streamline report generations. I have almost completed the project but I have ran into a problem I can't seem to figure out. I am fairly new to the VBA...
  11. R

    VBA -Code not working for 3 ranges

    got a code that allows you to select multiple values from a list. The below code works with 2 defined name sets (called "MY_RANGE" & MY_RANGE2") BUT stops when i add "MY_RANGE3" Private Sub Worksheet_Change(ByVal Target As Range) ------ Dim OldVal As String Dim NewVal As String...
  12. H

    Link multiple dropdown lists to always show the same value

    Hi all! Your help with this would be greatly appreciated. I have 2 dropdown lists using the same source. When the value in either List 1 or List 2 is changed via the dropdown, I want the other to change to match. I've got it working for one using the below VBA code, however, if I repeat the...
  13. M

    Drop Down - Partial Result from Selection

    Similar to Drop Down thread: Drop Down (would simplify that one if this is possible) Below is an example of what I'm looking at. Seeking a non macro solution to have drop down display as shown, but enters only the code portion, so if A: Apple was selected in C3 it would return...
  14. M

    Dynamic dropdown from Table

    I have the following table: Brand Type ProductName Brand A 100 Product_01 Brand A 100 Product_02 Brand A 200 Product_03 Brand A 200 Product_04 Brand A 300 Product_05 Brand A 300 Product_06 Brand B 100 Product_07 Brand B 100 Product_08 Brand B 200 Product_09 Brand B 200...
  15. R

    How to get dynamic Dropdowns based on the header cell such that the dropdown options are from range, named header cell, in another Source Workbook?

    Hello everyone, I am struck with this problem since yesterday and have been unable to find any solution despite all the web searches. Please help me if it is indeed possible. To better explain the situation: We have multiple templates for different product types (400+). We share these files...
  16. S

    How to prompt an input box and add comment when certain value is selected

    Howdy y’all, I am working on a sheet that will ultimately have a lot of non-Excel-savvy folks using it. For that reason, I’ve been asked to protect the sheet to limit how much can be edited. As such, I don’t want to allow “edit objects” when protecting because there are several shapes/text...
  17. B

    Using VBA to automate dependent dropdowns.

    Can Macros be used to go through a lists in one worksheet (A) to change four dropdowns on another worksheet (B)? Dropdowns 3 and 4 are dependent on number 2, and the number of rows on worksheet A can be over 100 at times. New to VBA and coding and literally do not know if it can be done and...
  18. T

    Dynamic/dependent Dropdown inline tables (de-normalized source)

    Dear MrExcel-Community, once again an dependent dropdown question, but I haven't seen a solution (no VBA) for my problem. I've seen a couple of approaches putting values into separate ranges and refering then with INDIRET in data validation, but vor some reason I require the format you see in...
  19. MDHolmes

    Populating a wage based on a drop-down list

    I'm pretty much self-taught on Excel, and I'm really having trouble with this... I have two worksheets in my spreadsheet, the first is Labour Tracking, the second Data. My Data worksheet has a list of seven employees in Column A and their corresponding wage in Column B. The number of...
  20. G

    dropdown list based on filter function result

    Hi, I am trying to create a dropdown list based on the results from a filter function. Here's an example : I used Filter function (in B1) to get the results containing the word rose from column D. However this fills the cells B1 to B3, instead I would like to get a dropdown menu. I used...

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