Can someone please help me with 3 dependant combo boxes, which automatically populate with unique values from column A, B and C.
I have attached a simple spreadsheet as an example of what I am trying to achieve here.
I have a huge worksheet called “data”. On another worksheet called “filter”, I would like 3 combo boxes. I want combobox 1 to populate from column A from data worksheet with unique values. Then depending on what is selected in combobox1, I would like combobox2 to populate values from column B and then depending selection based on combobox 1 and 2, I want combobox3 to populate values from column C. All selections need to be optional; user may just want filter data by using any of 3 combo boxes.
Once user has made all 3 or 1 or 2 selections, I want records from data worksheet (from certain columns only) to be filter and display on Filter worksheet. I hope it makes sense when looking at attached example workbook.
Thanks in advance for your help.
Bookmarks