vba - Clicking a hyperlink in Excel to set autofilter on a different sheet -

i have excel workbook 2 sheets, one-to-many setup between 2 sheets. first sheet lists several hundred companies , second sheet lists board of directors of companies. second sheet has auto filter users can see board members specific company selected filter.

what attempting have user click cell of company on first sheet user taken next sheet auto filter populated company selected. way user has direct access board members company selected.

i imagine require vba , hoping point me in right direction creating code solve this. many thanks.

you can accomplish doing in worksheet module:

private sub worksheet_beforedoubleclick(byval target range, cancel boolean)     'update table14 table name     'update field column number of field filtering     'update sheet7 reference sheet containing table     'change on column number click should cause action     if activecell.column = 1     sheet7.listobjects("table14").range.autofilter field:=1, criteria1:=activecell.value     'update sheet7 reference sheet containing table     sheet7.activate     end if end sub