Create multiple hyperlinks to cells in different sheet

[Arnebjarne]

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!

[tim201110]

Please Login or Register  to view this content.

[humdingaling]

Non VBA method

in an adjacent column or any free column (lets say N in this example)
type in
N1 = 3
N2 = 16
N3 = 29
highlight and fill down to 1002, it should map your pattern

then in cell M2 type in ="=Sheet2!B"&N1 and fill down to 1002 again

highlight column M - Copy and paste values
while M is still highlighted run text to column and click finish

this sounds like many steps but its not really