Hyperlink Relative and Absolute Cell copying

[Spikadelia]

Hi all,

I'm asking the wider community of expert knowledge to help me crack a problem that a novice like me can't work out even after trawling the interwebby.

I have a workbook with two sheets. The first sheet has a lot of number data, the second has descriptions etc.

I want to hyperlink from a cell on sheet 1 (B2) that links to the info on sheet 2 (C2). So far so good, I've done this using the standard hyperlink and the formula hyperlink way and editing text display with ease.

What I can't work out is how to copy the hyperlink so that the row cell reference changes in context so that sheet1 B4 links to sheet2 C4 or B5 to C5 without editing every cell: the hyperlink/formula stays the same whether I copy+paste or drag paste.

Help would be appreciated in layman's terms. Thanks in advance.

S

 

[Spikadelia]

Just to bump this since I'm sure one of you can answer this in a second but it's a brick wall + head situation for me.
Thanks.

 

[Spikadelia]

This is my last attempt to ask the community re this question.
It would be great if someone can help out.
S