I have a hyperlink on one Excel sheet that takes me to data on another sheet based on matching the text in a certain cell. My sheet contains a hyperlink in each row. Each hyperlink I click takes me to another sheet based on the text from column in that row. Here's my hyperlink formula...
=HYPERLINK("#'Report'!"&ADDRESS(MATCH(A2,Report!A:A,0),3),"View")
The hyperlink matches the data in column A of my row with the first row containing that same text on my "Report" tab and takes me to that row.
What I'm looking for is a macro that is triggered when I click on the hyperlink to highlight all rows containing that same text (the text from column a of that hyperlink row) on the "Report" tab. So basically, I want to click the hyperlink on my "Summary" tab, it will take me to the first row on the "Report" tab containing the same text found in column A current row on the "Summary" tab. Then at the same time as the hyperlink takes me to the "Report" tab to find my specified text row, I also want it to kick off a macro to highlight all rows containing this same specific text a different color.
Is this possible?
=HYPERLINK("#'Report'!"&ADDRESS(MATCH(A2,Report!A:A,0),3),"View")
The hyperlink matches the data in column A of my row with the first row containing that same text on my "Report" tab and takes me to that row.
What I'm looking for is a macro that is triggered when I click on the hyperlink to highlight all rows containing that same text (the text from column a of that hyperlink row) on the "Report" tab. So basically, I want to click the hyperlink on my "Summary" tab, it will take me to the first row on the "Report" tab containing the same text found in column A current row on the "Summary" tab. Then at the same time as the hyperlink takes me to the "Report" tab to find my specified text row, I also want it to kick off a macro to highlight all rows containing this same specific text a different color.
Is this possible?