Filtering with Custom made Combo Box

[Andrew.Trevayne]

Hi all,
I would like your help in a report that I am working on.
It's quite complicated to me and I hope you can take some time to help me.
I'm desperate!

I have 2 sheets, actually a lot but I didn't include on the dummy Excel sheet as it is not relevant.

On my Sheet1 (Sales Dashboard) contains combo boxes and a Table.
On my Sheet2 (DataSource) is the value lookup.

What I'd like to do is to create some sort of filter.
When clicking "Run Query" button I would like to populate my table
(starting from C42 of Sales Dashboard Sheet) based on the choices of my Combo box.

I'm so desperate and I really really need your help.
Thank you so very much in advance.

PS
I have attached my dummy worksheet.

[PCI]

See attached your file with some slight modifications: Linked cells for combox changed and columns reference for filter added.

Please Login or Register  to view this content.