Link to other sheet cell, locked to row 1

phil.hardy

I know how to use "Link from cell in other sheet", but what I would like to do is link to an absolute cell reference, in a particular column in row 1 at all times. This is so when I add new rows to the top, the new row 1 content in a particular column will show in a fixed cell location in another sheet. Is this possible, as I have not been able to find an answer as yet in my search? Thanks in advance!

phil.hardy

Okay, I think I may have solved my question, with a bit of trial and error. What appears to be working is as follows:

=INDEX({1003 Hire Record Range 1}, 1)

The selected range is the whole column of which I want to pull the single cell value from, being always row 1 of that column. This seems to work. I tried a few other different range selections which would exclude new rows added to the sheet; if I selected complete rows in the sheet.

phil.hardy

Okay, I think I may have solved my question, with a bit of trial and error. What appears to be working is as follows:

=INDEX({1003 Hire Record Range 1}, 1)

The selected range is the whole column of which I want to pull the single cell value from, being always row 1 of that column. This seems to work. I tried a few other different range selections which would exclude new rows added to the sheet; if I selected complete rows in the sheet.