Excel/VBA Question

[Zdesgain11]

I am trying to determine if this is even possible within excel:

I have a Summary Tab with a list of different customers in it. I also have a "Dashboard" tab that is an dynamic/filterable dashboard with slicers. On this dashboard, you can select which customer you want to view via the Slicer, and the dashboard changes to that customer's data based on a data tab and formulas.

My question is: Is there a way to be able to click on a customer in the Summary tab and it take me to the dashboard tab with that particular customer selected within the slicer.

I know you can do hyperlinks within excel that will take you to different tabs, but don't think it is possible to make it select the particular customer without the use of VBA?

Thank you!

 

[MARK858]

Not sure that I am reading this correctly so what is being done in the link below something like you mean?

How to create dynamic hyperlink based on specific cell value in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com