hyperlink not moved when wanted

[larremail]

I have two sheets.

Sheet 1
A1 contains a hyperlink to www.google.com

Sheet 2
in cell A1 I've written "=Sheet1!A1". The text is there but the link is not.

Why?

pls help

/ L

 

[Robert Mika]

Try this:

=HYPERLINK(Sheet1!A1,Sheet1!A1)