How to combine hyperlink and filter into one-click
 

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

How to combine hyperlink and filter into one-click
 

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