Hyperlink Relative and Absolute Cell copying

Spikadelia

New Member
Joined
Mar 10, 2011
Messages
3
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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Spikadelia

New Member
Joined
Mar 10, 2011
Messages
3
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

New Member
Joined
Mar 10, 2011
Messages
3
This is my last attempt to ask the community re this question.
It would be great if someone can help out.
S
 

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,610
Members
414,080
Latest member
penguin23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top