Count values and make it possible to double click those values and filter the table

[kjellis]

Hi,
This is my first post on this excellent forum, earlier I have just found a lot of help using the search function. Though I can’t find any good solution for this problem.

I need a Macro that response on double click and apply auto filters in a table. The applied filter need to be conditional in which cell the double click is made.

This could properly be seen as 2 separate parts.

Part 1.
Set up a Matrix and count statistic from a data table using VBA.
* I would like to use the row name and column name as conditions.
* Each cell in the Matrix should just contains the value that matched the conditions.
(I have used the function COUNTIFS in the attached file).

Part 2.
Be able to double click in the matrix and apply correct filter at the table.
* E.g. If I double in cell C7 I would like the table to be filter and just show the four cars that belongs to “Nisse” and is a “Type A” car.

I have attached a file that proberbly help you to understand my question.

I use Excel 2007 and pivot table could be used but is not the solution in this case.

Best regards

[kjellis]

No replies yet =/

Can any one help me if I reformulate the question to:

* If I double click inside the range A1:E10
* I would like to identify the value in the left column (Col A) at that row number
* and identify the value in header in the matching column.

Eg.
* If i double click C3
* I would like to identify the value in A3
* and the value in C1

Hopefully i get some respons now.

Regards