INSERTING CELL DATA IN A HYPERLINK
 

I need to create a hyperlink that will pull info from cells in a worksheet

i.e. - IN THE FOLLOWING HYPERLINK WHICH REPRESENTS THE PAGE I AM CURRENTLY
ON I WOULD NEED TO REPLACE THE WORDS IN ALL CAPS WITH INFORMATION THAT I HAVE
IN SPECIFIC CELLS IN A WORKSHEET

http://www.microsoft.com/wn3/aspx/po...PERLIN K&pt=1

DOES THIS MAKE ANY SENSE? CAN ANYONE HELP?

INSERTING CELL DATA IN A HYPERLINK
 

If A1 contains cnn.com, then:

=HYPERLINK("http://www."&A1,"news")

is an example of making a hyperlink using cell contents.
--
Gary's Student


"K" wrote:

I need to create a hyperlink that will pull info from cells in a worksheet

i.e. - IN THE FOLLOWING HYPERLINK WHICH REPRESENTS THE PAGE I AM CURRENTLY
ON I WOULD NEED TO REPLACE THE WORDS IN ALL CAPS WITH INFORMATION THAT I HAVE
IN SPECIFIC CELLS IN A WORKSHEET

http://www.microsoft.com/wn3/aspx/po...PERLIN K&pt=1

DOES THIS MAKE ANY SENSE? CAN ANYONE HELP?