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...
I have a Table, with 3 column. In picture I showed what I want. I need 3 dropdown list that depend each.
List 1= list cul-1 (without duplicate).
list 2= everything in Cul-2 related to return of list 1 (without duplicate).
list 3= everything in Cul-3 related to return of list 2 (without...
Hi,
I'm looking to create a macro that will allow me to setup a spreadsheet template whereby the user is prompted to select one value, then another and on the basis of these 2 other values are populated. So for example, the user is prompted to choose a category and then a division, which then...
I am new to using the Developer tab and Combobox's in Excel. I am working on a spreadsheet for work and want to use some code I found online. I want the combobox to pull data from multiple (dynamic, if possible) data validation lists (demographic info) on a separate sheet. The sheet I want to...
Hello all,
After searching like crazy, I am stuck as to how to create a dynamic drop down list using VLOOKUP.
In one workbook:
I have an input worksheet where employees enter their data and the data gets transferred to a master-list via button (macro). Every employee row in the master-list...
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.