Results 1 to 3 of 3

Thread: Automatic Filter on Hyperlink in Excel

  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Automatic Filter on Hyperlink in Excel

    Hi,

    I would like to know if there is a way where when I do a hyperlink on one cell with a value, then I can automatically filter the spreadsheet with that value on that cell? to further explain, I am attaching here an example of what I would like to have.

    In my attached example, I have a value A to D from A1 to A4. Then I have the values A to D in cell A7 to A18.

    I would like to have that if I clicked the A in cell A1, then it will automatically filter the A in cells A7 to A18.

    The same if I clicked B, C or D.

  2. #2
    Join Date
    Mar 2012
    Posts
    2

    re: Automatic Filter on Hyperlink in Excel

    Im not sure if my attachment has gone through but anyway I am sending here the image of the spreadsheet. It is only a simple one so image should be good enoguh.

    Thanks.


  3. #3
    Join Date
    Aug 2011
    Posts
    460

    Re: Automatic Filter on Hyperlink in Excel

    This is possible via vba. The more easy way you can do this is by setting up a filer button on the top of row. It will calculate the blank rows also. To setup a hyperlink for that you will need to find a script or setup a macro for the procedure. I will recommend you to try on web to find a ready to use script for this and test it out.

Similar Threads

  1. Hyperlink not working in Excel 2007
    By Technocrat52 in forum Windows Software
    Replies: 4
    Last Post: 28-03-2012, 12:24 PM
  2. Want to hyperlink only one word in a cell of Excel
    By Iyyappan in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 07:24 PM
  3. why hyperlink not working on Excel?
    By Chheda in forum Windows Software
    Replies: 4
    Last Post: 04-01-2012, 08:32 PM
  4. Macro for hyperlink on Word/Excel
    By Mindstorm in forum Windows Software
    Replies: 3
    Last Post: 07-05-2009, 03:13 PM
  5. Picollator filter : Automatic adult content filter
    By monsitj in forum Windows Software
    Replies: 1
    Last Post: 29-01-2009, 07:07 PM

Tags for this Thread

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
  •  
Page generated in 1,710,849,147.80407 seconds with 16 queries