'How to hyperlink column different sheets automatically? | EXCEL
I have two tables in Excel, I want to create a column in table1 with the same names as one column in table2 and hiperlink too. I write in table1:
= table2!A1
And copy the formula to all the rows, perfect, the problems comes when I want to HIPERLINK, I have done this:
=HIPERLINK("#table2!A1"; table2!A1)
But then I copy and paste its only updated the second term, the text, not the link. So all field have the right name but pointing to the same place.
Is it possible to do this without VBA?? Tried so many different ways already...
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|