Populate table based on criteria from another table

I've been having trouble figuring out how to do this one. Unfortunately I'm not proficient with VBA.
What I have to figure out how to do is:
On the "Statistics" sheet I want to be able to double click on any of the statistics numbers and have it populate a table on the "Statistic List" sheet with all rows matching specific criteria from the "Master Sheet" (I would like it to also clear itself of previous data anytime a new cell is double clicked)
All of the notes on the "Statistics List" will be deleted as well, just forgot to do it before posting the workbook.

I don't want to take up a lot of anybodies time so if someone would be able to just provide a couple examples (preferably including one of the ones that has a NOT criteria)
All of the cells on the Statistics worksheet are already fitted with their criteria, I just don't know how to do it in VBA.

To give a more specific example:
IF I double click DEPLOYABLE under the hardware column on one of the tables (on the Statistics sheet)
(Firstly I need it to clear the table on the "Statistic List" sheet of any records currently there)

I need it to match from the columns on the Master sheet(Table2)

Agency = ""
AND
Pool = "Hardware" OR "Hardware & Certification"
AND
V-ID = NOT Null(or 0, however excel does it)
AND
Induction = "Yes"
AND
BGV = NOT "Pending Candidate Review"

and then populate a table on the "Statistic List" sheet with all qualifying rows from the master sheet(Table2)

Attachment 307851

I appreciate the effort anyone puts into this. *Grovel*

Somehow I managed to figure this out on my own.

So for anybody that uses these forums as a reference I'll post the Macro I came up with.

Please Login or Register  to view this content.