INSERTING CELL DATA IN A HYPERLINK

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K - 28 Nov 2006 10:43 GMT

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/postui.aspx?query=INSERTING+CELL+DATA+IN+A+HYP
ERLINK&cat=en-us-excel&lang=en&cr=US&guid=&sloc=en-us&dg=&base=http://www.micros
oft.com/office/community/en-us/wizard.mspx&bclr=ececec&fclr=000000&sxml=http://w
ww.microsoft.com/office/community/en-us/site.xml&stgxml=http://www.microsoft.com
/office/community/en-us/settings.xml&sdgloc=en-US&fwizard=1&sub=INSERTING+CELL+D
ATA+IN+A+HYPERLINK&pt=1

DOES THIS MAKE ANY SENSE? CAN ANYONE HELP?

Reply to this Message

Gary''s Student - 28 Nov 2006 13:30 GMT

If A1 contains cnn.com, then:

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

is an example of making a hyperlink using cell contents.

Signature

Gary's Student

> I need to create a hyperlink that will pull info from cells in a worksheet
>
[quoted text clipped - 5 lines]
>
> DOES THIS MAKE ANY SENSE? CAN ANYONE HELP?

Reply to this Message