Results 1 to 4 of 4

Thread: Filter data based on combobox value problem

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jun 2007
    Posts
    157

    Filter data based on combobox value problem

    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?

    Thanks in advance
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width