populating a listbox from a search query

All,

I have a small problem with a macro.

On the attached spreadsheet, I have a command button on the search results spreadsheet that opens a userform to show the individual records with populated data.

This is working fine. The problem is when I use the 'drill down' button beforehand.

As an example, I search for the language "Italian". I then drill down to find "Females". When I click the command button and click Find, I only want the 3 records for the females, not the 7 that match the original search.

I know where in the macro changes are required, I just don't know what to change it to.

Can someone help?

Thanks

Hi,

Try the attached,

I think the extracting can be simplified by using an advanced filter instruction which only requires one line of code. It meant adding a few extra range names and making the column labels unique but you should be able to see the general idea. I moved your original button and combobox out of the way and just let the twin input cells F2 & G2 be drop down cells with a Filter Records button alongside.

HTH