Hello, everyone,

I have a question and I don't know much about macros and VBA, I would like to create a hyperlink in a cell in Excel to another Excel file, in which it automatically sets a filter with the "number" in the original cell of the file. Since I have too many numbers in the second Excel file, I would like to have all numbers filtered by one click.

I hope I could express myself correctly.

Many thanks in advance!

Yours sincerely

synopsis