Hyperlink copying I have a workbook with two worksheets. On page 1, I have a hyp

Question

Hyperlink copying
I have a workbook with two worksheets. On page 1, I have a hyperlink to a particular cell in page 2. I want to have many hyperlinks to the second page. These links are in all in the same column on page 2 in the same order as the hyperlinks in page 1. Is there any way to drag the link down and have the cells below autofill with the Hyperlinks correlating to the same order on the second page? Sorry if this sounds confusing. I have over 600 hyperlinks that need to be on page 1, linked to the same number of links on page 2, all in the same order, row after row. Can I do this easily or do I have to simply have to copy the first link into the cells below and then edit each hyperlink to direct to the correct row number in the second page? Please advise. Thanks.

Explanation / Answer

^#$%&#@%&

Let's say you want hyperlinks to the cells in column B on Sheet2 in Book1.xlsx.

Enter the following formula in the first row on Sheet1:

=HYPERLINK("[Book1.xlsx]Sheet2!B"&(ROW()-ROW($A$1)+1)

You can fill this down as far as you want.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.