ExcelBanter - How do I keep a cell reference the same even if a row is inserted?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I keep a cell reference the same even if a row is inserted? (https://www.excelbanter.com/excel-discussion-misc-queries/180420-how-do-i-keep-cell-reference-same-even-if-row-inserted.html)

apr

How do I keep a cell reference the same even if a row is inserted?

EG. My cell reference in Sheet1 is ='sheet2'!$A$2 but if a row is inserted on
Sheet2 above relevant row the formula changes to ='sheet2'!$A$3.
I want it to remain the original reference regardless of any changes on
Sheet2.

Gary''s Student

How do I keep a cell reference the same even if a row is inserted?

=INDIRECT("Sheet2!A2")

--
Gary''s Student - gsnu200774

Max

How do I keep a cell reference the same even if a row is inserted?

=INDIRECT("'Sheet2'!A2")
would be one way to always point the link at Sheet2's A2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"apr" wrote:
EG. My cell reference in Sheet1 is ='sheet2'!$A$2 but if a row is inserted on
Sheet2 above relevant row the formula changes to ='sheet2'!$A$3.
I want it to remain the original reference regardless of any changes on
Sheet2.

All times are GMT +1. The time now is 06:49 PM.