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

VBA Coding Help for Beginner 0
Need Help with a VBA subroutine 0
Search and Link across worksheets 2
Extend formula row reference across columns 1
Formula fill series? 1
Automatically copying data from sheet1 to sheet2 2
Conditional sum in a named range 8
Transpose between sheets 4

Top