How to combine hyperlink and filter into one-click

  • Thread starter Thread starter James Wang
  • Start date Start date
J

James Wang

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.
 
Back
Top