I am trying to make one cell show the formula from another cell, rather than the 'answer'. Example:
A1 --> =B1
B1 --> is a hyperlink
What I need is for A1 to give me the same hyperlink, rather than the text that is shown.
I don't know if this is even possible.
Thanks for your help.
A1 --> =B1
B1 --> is a hyperlink
What I need is for A1 to give me the same hyperlink, rather than the text that is shown.
I don't know if this is even possible.
Thanks for your help.