Lock reference cells for links within workbooks
 

How do I lock the source cell when creating a link within worksheets? Right
now the cell changes if I insert cells, and i want the cell reference number
to always remain the same, so the cell linked to it changes as I change the
linked cell.

Lock reference cells for links within workbooks
 

You can use the INDIRECT formula, like this:

=INDIRECT("Sheet1!B12")

to get data from cell B12 of Sheet1, for example. This will always get
the data from that cell, even if you insert or delete rows or columns
in Sheet1.

Hope ths helps.

Pete

On Aug 5, 12:43*am, Teacher Help <Teacher
wrote:
How do I lock the source cell when creating a link within worksheets? *Right
now the cell changes if I insert cells, and i want the cell reference number
to always remain the same, so the cell linked to it changes as I change the
linked cell.