Hi Guys!!
I'm using the Hyperlink function for a database with different sheets. On my main sheet I have the label of each element, and on my second sheet I have each element with an individual table with some data.
The issue is that I need to link the label on the first sheet with the table of the element on the second sheet. For that, I used:
=HYPERLINK("#'Sheet2'!A1", 'Sheet2'!A1)
Before extending this formula to all the remaining elements (2499). I hided on the Sheet2 all the rows that I dont neet to be linked. But the formula still link them, is there a way to make that HYPERLINK skip all the hided rows?
I'm using the Hyperlink function for a database with different sheets. On my main sheet I have the label of each element, and on my second sheet I have each element with an individual table with some data.
The issue is that I need to link the label on the first sheet with the table of the element on the second sheet. For that, I used:
=HYPERLINK("#'Sheet2'!A1", 'Sheet2'!A1)
Before extending this formula to all the remaining elements (2499). I hided on the Sheet2 all the rows that I dont neet to be linked. But the formula still link them, is there a way to make that HYPERLINK skip all the hided rows?