+ Reply to Thread
Results 1 to 6 of 6

VBA Code So when User Clicks on Cell, it will hyperlink to another sheet filtered

  1. #1
    Registered User
    Join Date
    02-08-2019
    Location
    USA, CT
    MS-Off Ver
    2016
    Posts
    3

    VBA Code So when User Clicks on Cell, it will hyperlink to another sheet filtered

    Hello,

    I have a sheet named "SE List $1b+". The first column in this sheet has client names. I want it when I click on the client it brings to another sheet which has client contact information. Instead of hyper linking manally to the reference, which would take forever because there are over 600 clients, I want the user to click on the client and bring that second sheet filtered, which is called "SE $1B+ accounts with employee" which matches up the client name. Can anybody post code so I can achieve this? Appreciate it!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,687

    Re: VBA Code So when User Clicks on Cell, it will hyperlink to another sheet filtered

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.

    -




    See clip
    To add a file to a post

  3. #3
    Registered User
    Join Date
    02-08-2019
    Location
    USA, CT
    MS-Off Ver
    2016
    Posts
    3

    Re: VBA Code So when User Clicks on Cell, it will hyperlink to another sheet filtered

    Here I uploaded a dummy document. On sheet 1, lets say I click on ICBC, I want it too go to sheet 2 and filter out company name with only ICBC contact information. Hopefully somebody can post any code. Thanks!
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,687

    Re: VBA Code So when User Clicks on Cell, it will hyperlink to another sheet filtered

    Using worksheet events.
    This goes into the worksheet module.

    Read this thread on Worksheet events and where the worksheet module is.

    https://www.excelforum.com/tips-and-...et-events.html


    Please Login or Register  to view this content.
    Click column B sheet 1, to execute the code
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-08-2019
    Location
    USA, CT
    MS-Off Ver
    2016
    Posts
    3

    Re: VBA Code So when User Clicks on Cell, it will hyperlink to another sheet filtered

    WOW!! This worked thank you!! What if I want to filter out two different sheets, I have another sheet with more client information that might not be on the first sheet. What extra code do I add for another sheet to be filtered out when I click on the client on the first sheet? Thanks alot!!

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,687

    Re: VBA Code So when User Clicks on Cell, it will hyperlink to another sheet filtered

    I don't know I just went with the sample you supplied.

+ 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