+ Reply to Thread
Results 1 to 10 of 10

Hyperlink VBA code

  1. #1
    Registered User
    Join Date
    02-17-2022
    Location
    India
    MS-Off Ver
    365
    Posts
    54

    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

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: Hyperlink VBA code

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

  3. #3
    Registered User
    Join Date
    02-17-2022
    Location
    India
    MS-Off Ver
    365
    Posts
    54

    Re: Hyperlink VBA code

    Attached sample file .
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: Hyperlink VBA code

    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.

  5. #5
    Registered User
    Join Date
    02-17-2022
    Location
    India
    MS-Off Ver
    365
    Posts
    54

    Re: Hyperlink VBA code

    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.

  6. #6
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: Hyperlink VBA code

    I cant fix the code without a file to work on. Id just be guessing.

  7. #7
    Registered User
    Join Date
    02-17-2022
    Location
    India
    MS-Off Ver
    365
    Posts
    54

    Re: Hyperlink VBA code

    i shall notbe sharing the exat file but i can provide a dummy with same columns n format of my data .
    But thanks so much for the help , Really Appreciate
    I am sharing a dummy version thou . please see if you can help , unable to arrive at the filtering ..
    Also there is comment in Amber on the summary sheet if you can help with
    Attached Files Attached Files
    Last edited by deepa.iyer; 03-10-2022 at 07:08 AM.

  8. #8
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,909

    Re: Hyperlink VBA code

    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.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    02-17-2022
    Location
    India
    MS-Off Ver
    365
    Posts
    54

    Re: Hyperlink VBA code

    This is brilliant . Many thanks for all the help to go about this .

    Appreciate it .. Thanks a ton again

    Will you be able to help with my below thread please .

    i dont know how to post the link to it here and guess i am not allowed to ..post name is - Merge / consolidate around 17 to 18 sheets with different column header names
    Last edited by deepa.iyer; 03-11-2022 at 03:33 AM.

  10. #10
    Registered User
    Join Date
    02-17-2022
    Location
    India
    MS-Off Ver
    365
    Posts
    54

    Re: Hyperlink VBA code

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hyperlink VBA Code
    By KatieA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2020, 01:34 AM
  2. [SOLVED] code for hyperlink
    By Evolta in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-18-2013, 03:37 AM
  3. [SOLVED] VBA code for Hyperlink
    By rcmanivannan in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-29-2013, 11:47 PM
  4. Hyperlink to run VBA code using auto fill for =hyperlink
    By chevelle8719 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2010, 02:45 PM
  5. Hyperlink Code
    By oberon.black in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2005, 06:05 PM
  6. [SOLVED] Using Hyperlink via code
    By mick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2005, 06:06 PM
  7. Hyperlink via code
    By Mick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1