Thursday, 15 March 2012

excel - How to convert a list of cell references to cells in other worksheets into hyperlinks -


I have an abstract worksheet that contains references to other worksheets within a single workbook. These references are simple form (i.e. = Sheet2! D23). I want to convert them to hyperlinks I want hyperlinks to display the value of the referenced cells.

I can do this personally but the spreadsheet is large and these are hundreds of references.

Can someone suggest an easy way for batch to convert these references to hyperlinks?

If you want to link, then run this macro.
It will only link the values ​​located on a separate sheet, it will not link to the cells present on the current sheet. If you want to link all the cells, even if the value comes from a single sheet, then only replace if..End if wrapcode around rng.Hyperlinks.Add rng (Rng) formula, "=", "") .

  Sub-makeLinks () Select RNG for RNG as the Range for each RNG in the selection. If rng.Formula "= *! *" Then RGG Hyperlink.Add RNG, "", Change (RNG. Formula, "=", "") End if the next RNG and sub    

No comments:

Post a Comment