CODEWITHSUNDEEP
excelhyperlinkformula
user2968604
user2968604

Reputation: 9

Excel Copy Hyperlinks Formula

I have a problem with excel hyperlinks-formula:

I did an index search on a sheet B where i found results from sheet A. The results found in sheet A are hyperlinks on sheet A.

Now my Problem is, that i want to have the results found also as hyperlinks which link me to the same sheets (C-Z) like sheet A.

I tried Hyperlink(Index(....)), but it won'T work.

Any ideas?

Upvotes: 0

Views: 8514

Answers (1)

Bflat
Bflat

Reputation: 47

Step1: Select your result in sheet B, by selecting the top cell and doing cntr+shift+Down.

Step2: Copy and paste it as values in a adjacent column (Say column B) by doing Alt+E+S+V.

Step3: In a column adjacent to the result column from Step2 in your sheet B, type in the formula =HYPERLINK(B1) (replace B1 with whatever cell you copied your values to in Step2).

Step4: Copy the formula down by dragging the corner of the cell from Step3.

Step5: You are done.

Upvotes: 0

Related Questions