+ Reply to Thread
Results 1 to 3 of 3

Hyperlink Autofilter Parameters

  1. #1
    Registered User
    Join Date
    06-23-2006
    Location
    Amsterdam
    Posts
    3

    Question Hyperlink Autofilter Parameters

    Hi, I have a workbook with 2 sheets with data from an external database.

    Sheet 1 is "Products" and sheet 2 is "Issues". On the first sheet i have a clumn where i do a lookup for eacht product to see if there are one or more Issues listed on the "Issues" sheet. If any issue is found i want to make a Hyperlink in the next collumn on the "Products" sheet. For this i used the following formula

    =IF(VLOOKUP(L4;Issues!A:G;4;1)=1;HYPERLINK(Issues!$A$1;"Issue");"").

    For now this works!

    The next think i would like to do is when i click the hyperlink i want to go to the "Issues" sheet and modify the autofilter parameters so i only the issues for the according product on the "Products" sheet.

    If anyone can help please let me know
    Thanks in advance, Boekkie

  2. #2
    Registered User
    Join Date
    06-23-2006
    Location
    Amsterdam
    Posts
    3

    Sorry

    Sorry for the other threads i created in this forum but something going wrong when i was posting my post and now there are 3 threads.

  3. #3
    Registered User
    Join Date
    06-23-2006
    Location
    Amsterdam
    Posts
    3

    Post Almost solved [Hyperlink Autofilter Parameters]

    My hyperlinks are now formatted as:

    =IF(VLOOKUP(L2;Issues!A:G;4;1)=1;HYPERLINK("#Issues!$a$2";"Issue");"")

    and i will end up at Cell A2 on the Issues sheet.
    I also found some information on how to make a hyperlink start a VBA routine

    Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
    x = Target.Range.Address
    Range("A1").AutoFilter Field:=2, Criteria1:="x"
    End Sub


    "Target.Range.Address" in this code should be the value of cell L2 as i used in the VLOOKUP.

    Any ideas on how to continue?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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