Need Help in Excel!

[john_the_papito]

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

 

I have 2 sheet

1 with costumer info: name, id, birthday etc.

2 with orders information

 

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.

 

I have been trying to find a solution to this porblem for days. can anyone help? even better send a video link

[xentropa]

i dont know about a link but you could use excel vba button macro to do what you want.

[xentropa]

https://www.extendoffice.com/documents/excel/4422-excel-run-macro-from-hyperlink.html

 

this site tells you how to do that.  If you need help with programming a macro, respond again.

[john_the_papito]

18 minutes ago, xentropa said:

i dont know about a link but you could use excel vba button macro to do what you want.

Hello can you look at the excel i uploaded so far im only able to link to another sheet. If posibble can you send a video link on how this VBA work to fix my problem.

test.xlsx

[xentropa]

K ill look at it when I have time.

[john_the_papito]

1 hour ago, xentropa said:

K ill look at it when I have time.

Hello agian,

 

I'm so close i have created hyperlinks to sheet 2 and macro for my costumer.

 

The only  ting, that is missing is the connection of my hyperlink to the macro on another sheet.

 

test.xlsm