A
aposatsk
I have a one column table in 1 workbook. Every time i enter text such as
"ABC", i would that text in that cell to be converted into a hyperlink
which is addressed to Sheet "ABC" in -another -workbook.
e.g.
I was thinking of making each cell a formula such as "if "Wilson,
Adam", then...., if "Kite, Alex", then..." but that is too impractical.
Is this possible?
"ABC", i would that text in that cell to be converted into a hyperlink
which is addressed to Sheet "ABC" in -another -workbook.
e.g.
Wilson, Adam (this will be a hyperlink to tab/sheet "Wilson, Adam" in
another workbook)
I was thinking of making each cell a formula such as "if "Wilson,
Adam", then...., if "Kite, Alex", then..." but that is too impractical.
Is this possible?