Hi!


I'm having a little trouble sorting out how to create multiple hyperlinks at once.

In column M in sheet1 I display the value of every 13'th cell from sheet2 column B, like so:

=Sheet2!B3
=Sheet2!B16
=Sheet2!B29

This goes on until B13016, so nearly 1000 cells.

I need to turn the displayed value in column M in sheet 1 into a hyperlink to the respective cell in sheet 2.
This is easy if I create every hyperlink manually, but it would take way too long time to do it to nearly 1000 cells.

Is there a easy way to do it?

Tnx!