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

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