hyperlinking columns together

G

GSBPT

I would like to hyperlink a column on one worksheet to a different column on
another sheet. For example I want B1 on sheet1 linked to D1 on sheet2.
Currently I tried to use the formula =HYPERLINK("[practice]Sheet2!D1"),
however I can't drag this formula down and have it change itself to
=HYPERLINK("[practice]Sheet2!D2") in the box B2. How would I do this?
 
J

Jim Cone

=HYPERLINK("[practice]Sheet2!D"&ROW(),"Click")
--
Jim Cone
Portland, Oregon USA



"GSBPT"
wrote in message
I would like to hyperlink a column on one worksheet to a different column on
another sheet. For example I want B1 on sheet1 linked to D1 on sheet2.
Currently I tried to use the formula =HYPERLINK("[practice]Sheet2!D1"),
however I can't drag this formula down and have it change itself to
=HYPERLINK("[practice]Sheet2!D2") in the box B2. How would I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extend formula row reference across columns 1
Conditional sum in a named range 8
Want A1 to receive contents of R (from MATCH()) and C (COLUMNS(R1) 9
Lookup formula 2
How to transfer a range from sheet to sheet? 4
counting how many of the same numbers 1
Fill Series for Lookup 2
Lookup with multiple returns 12

Top