PC Review


Reply
Thread Tools Rate Thread

How to combine hyperlink and filter into one-click

 
 
James Wang
Guest
Posts: n/a
 
      13th Nov 2009
Hi,

I was asked by my boss to build up a convenience mechanism for user by
clicking one cell on "Summary" sheet, and automaticaly hyperlinked to "Raw
data" sheet. In the meantime, autofilter fuction also works to show filter
result in the "Raw data" sheet.(different filter condition for different cell
on "Summary")

Briefly, preform "hyperlink" and "autofilter" by one-click.

Thank you very much!
James
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      13th Nov 2009
You can create an event macro that fires when the hyperlink is clicked. The
macro can determine which cell was clicked and set the filter accordingly.
--
Gary''s Student - gsnu200908


"James Wang" wrote:

> Hi,
>
> I was asked by my boss to build up a convenience mechanism for user by
> clicking one cell on "Summary" sheet, and automaticaly hyperlinked to "Raw
> data" sheet. In the meantime, autofilter fuction also works to show filter
> result in the "Raw data" sheet.(different filter condition for different cell
> on "Summary")
>
> Briefly, preform "hyperlink" and "autofilter" by one-click.
>
> Thank you very much!
> James

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Click hyperlink in ppt, it changes color, how 2 reset hyperlink co Rich Microsoft Powerpoint 2 29th Oct 2009 08:41 PM
Click hyperlink in ppt, it changes color, how 2 reset hyperlink co Rich Microsoft Powerpoint 0 29th Oct 2009 07:41 PM
Combine a Group Filter Control and Hyperlink/Server Filter on 1 DA =?Utf-8?B?U011cnBoeVBFUw==?= Microsoft Access 0 13th Oct 2006 02:42 PM
Combine Hyperlink with Text Lee Swain Microsoft Excel Discussion 1 4th May 2006 11:07 AM
Word: I create a hyperlink to a pdf. I ctrl-click on hyperlink, . =?Utf-8?B?QnJ1Y2U=?= Microsoft Word Document Management 0 18th Feb 2005 03:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:27 PM.