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

[J0hNTH3P4P7T0]

[FONT=&quot]I have 2 sheets

[/FONT]
[FONT=&quot]1 with costumer info: name, id, birthday etc.[/FONT]
[FONT=&quot]2 with orders information[/FONT]
[FONT=&quot]

[/FONT]
[FONT=&quot]I'm trying to find a solution to have a hyper link in sheet 1 beside the costumer id. That then autofilter all the order information in sheet 2 for that particular costumer.
So i have fast easy way to filter all order history that a costumer made.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I have been trying to find a solution to this porblem for days. can anyone help? even better send a video link[/FONT]