Home » Forums » Open Source Learning Center » Question and Answer

Cell Hyperlinks

Submitted by rmilos on 3 November, 2015 - 16:13

How can I link to a cell (which contains an existing external hyperlink) form a cell in a different spread sheet but within the same workbook?

‹ Creating a button/macro in excel to generate new workbook and save file as a number in a sequence Crazy optionbuttons ›
»

Qusetion

Submitted by oliblake14 on 3 November, 2015 - 17:39.

Is the cell that you are trying to link to displaying data from the hyperlink or is it just a hyperlink out of the workbook?

if its the display the data you can use =transpose or =index

=TRANSPOSE(sheet1!A1)

»