The HYPERLINK formula will not carry over to worksheet B, just the value
in 'potentials'!S2.

How about trying it this way.

In cell S2 of worksheet A, rather than the HYPERLINK formula, type in
your address as ="www.Exceltip.com"&R2. This will produce the site
address in text with the numeric value of R2 as the last part of the
address. (Assuming your site address always ends in the value that is
in column R).

In cell E3 of worksheet B, incorporate the HYPERLINK with the INDIRECT
formula like.

=HYPERLINK(INDIRECT("'Sheet A'!S2"),'Sheet A'!R2)

This will return the value in Sheet A!R2 as the name (12345678) to a
link at the address in SheetA!S2.

Does that solve it?


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=497982