I have 2 comboboxes that search a number of worksheets and add the filtered results to a named sheet. I have attached a working example of my file.
My problem is that I cannot get my second search for date to work. With my location search, the names are added to the combobox by code as they remain constant. The problem with the second combobox is I need to add the dates to the list and then be able to select a particular date resulting in a filtered sheet just like my location search.
1. I click on my combobox1 which runs the code to merge data from all worksheets begining with letter "D"
2. It then populates combobox1 with the dates in column "I" of my merged worksheet ("MasterSheet").
3. I can select a date from my list and it then creates a view based on the date selected.
I just cant get the dates to display in my combobox, can anyone spot what I am doing wrong?