Hyperlink VBA code

I have a summary sheet with data showing
Total items , closed items and open items counts country wise
As below
India. Europe. Chins
Parameter name total closed open t0t clo opn
Parameter 1 10. 1. 9. 83 13. 70


What I need is wen i click on open items for example india being 9
I want the code to go to pending items sheet put a filter on country header with the parameter header n show me only those open items ..

Help in this regard is highly appreciated

Post a file so we can assist as per the yellow banner above.

Attached sample file .

Place this code in the "summary Sheet" sheet module. It requires a doubleclick in the cell to activate.

Please Login or Register  to view this content.

Thanks much for the help,it works like a charm on the sample file , but not on my original data , it isnt filtering properly, as my original data has 8 such countries and the column count is 35 in total ...

in my original file the below code is not recognizing the Country name
For j = 5 To lc Step 4
If Target.Column >= j And Target.Column <= j + 4 Then
cntry = Cells(1, j).Value
End If
Also i just changed E3 to E6 in the code as per the original file ..
retunrs a blank hence the filtering isnt happening .
could you pls help .

Appreciate all your help.

I can’t fix the code without a file to work on. I’d just be guessing.

Your sample file was different than the original sample. The code was on the wrong sheet code as well. Here is the updated code and the working file.

Please Login or Register  to view this content.

Hello there , Your code works great still , i have a request into the same code ...
the above code fetched me data by filtering on Pending Sheet as per your code ,
Now i need to add the total items double clickevent on same code by Filtering only
the country on total items against the NC name . Meaning when i double click on Open column in my summary sheet ,
it will Do a filter of Pending Items and when i double click on Total columns in Summary sheet ,
it should Filter on Total using the same filter criteria of COuntry and NC name .
Could you Please help me . Appreciate all your

Attached sample file as well with a extra sheet total