Hello,
I am working with a worksheet with several tabs, for simplicity lets assume I have two, one with some aggregate figures (call it F) and one with all the data (call it D). Data in D is read in from CSV.
Each figure in F represents a set of data from D, I want to make a link from a specific figure in F to D in such a way that when link/button is pressed at figure in F it will jump to D and filter out those rows that are supposed to be showed in connection to that specific figure.
When I look at hyperlinks I see that it is not possible to link to a subroutine so a button of some sort needs to be created or is it possible to do this otherwise?.
I am just wondering if any of you have done this before and if you have any suggestions?
I am working with a worksheet with several tabs, for simplicity lets assume I have two, one with some aggregate figures (call it F) and one with all the data (call it D). Data in D is read in from CSV.
Each figure in F represents a set of data from D, I want to make a link from a specific figure in F to D in such a way that when link/button is pressed at figure in F it will jump to D and filter out those rows that are supposed to be showed in connection to that specific figure.
When I look at hyperlinks I see that it is not possible to link to a subroutine so a button of some sort needs to be created or is it possible to do this otherwise?.
I am just wondering if any of you have done this before and if you have any suggestions?