Hyperlink

  • Thread starter Thread starter Rooky228
  • Start date Start date
R

Rooky228

I am working with a spreadsheet with two tabs of 1,000 rows. I would like to
hyperlink from one to the other. I can install a hyperlink in row one, but
when I try to copy and paste for the next 999 rows, the link stays up on row
one instead of following down the the next rows.

Is there a way of propogating a hyperlink down the page without having to
enter manually enter it in each cell?
 
Use a Hyperlink formula in an adjacent column.
The following formula links to the cell in Column B of Sheet2 that is in the
same row as the hyperlink formula. The formula can be filled down or up.

=HYPERLINK("[TestBook.xls]Sheet2!B" & ROW(),"Click Me")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Rooky228"
wrote in message
I am working with a spreadsheet with two tabs of 1,000 rows. I would like to
hyperlink from one to the other. I can install a hyperlink in row one, but
when I try to copy and paste for the next 999 rows, the link stays up on row
one instead of following down the the next rows.

Is there a way of propogating a hyperlink down the page without having to
enter manually enter it in each cell?
 

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

Excel Macro to hyperlink an archived worksheet to an index page 0
Update a hyperlink in excel spreadsheet 5
Open specific hyperlink (accept) automatically in email with outlook 0
Adding row to sheet; having hyperlinks follow 2
Can Autofill be used for Hyperlinks 1
HyperLinks 4
Hyperlink cell references 2
Will not auto open .jpg 1

Back
Top