Thanks, Steve. Please excuse if this creates a duplicate post, but I did not
see the one I sent in response to your most recent.

Here is the setup.

Workseet A has a set of values in R:R such as 12345678, which pertain to a
page such as http://www.somewhere.com/abscd.asp?addrs=12345678. R2 may
display 12345678 and R3 may have 23456789, etc to infinit y.

Worksheet A column S:S has this formula:

=HYPERLINK("http://www.somewhere.com/abscd.asp?addrs=" &R:R ). Which
displays a clickable link.

As I work the data in Worksheet A, I start in row 2 and work down then purge
or move the data so that row 3 becomes row 2, etc.

Worksheet B cell E3 has this formula in it:

=Worksheet A!S2

which displays http://www.somewhere.com/abscd.asp?addrs=12345678, or the
current record, but as plain text.

I need for this to be a clickable link in Worksheet B.

Thanks again!

Norberto

"SteveG" wrote:


I created a sheet named A, B & C.

In Sheet A, I entered in cell A1 "B2". In sheet B, cell R2, I entered
=INDIRECT(A!A1) which returned the value in cell B2 of Sheet A which in
this case is 12345678.

Does the above describe basically what you are doing? If so.

In Sheet B, S2 I entered,

=IF(R2=12345678,HYPERLINK("http://www.exceltip.com",R2),"")

This returned a named hyperlink of 12345678 that when clicked opened
Exceltip.com.

I may be missing something. If you could provide your formulas and
data, I could take a look.

Steve


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