Static Cell Reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have a workbook with multiple worksheets. Sheet 1 is my summary sheet and pulls information from my other sheets. The problem I am having is that I set a static reference on sheet 1 cell A1 to say cell sheet2 cell B1. Whenever I come in the next day I insert a new row that way row 1 is always where I am pointing my reference from sheet 1 Cell A1. However, When I insert the new row my reference on sheet 1 now become sheet 1 A2. I have tried adding the $A$1 static identifier to the reference, however, it still dynamically updates. Is there a way to create this reference without the reference dynamically updating whever I insert a new row in sheet 2

Thanks in advance
Nelson Ferry
 
Hi Nelson
one way: insert the following in sheet 2
=INDIRECT("'sheet1'!A1")

--
Regards
Frank Kabel
Frankfurt, Germany

Nelson Ferry said:
Hello,

I have a workbook with multiple worksheets. Sheet 1 is my summary
Click to expand...
sheet and pulls information from my other sheets. The problem I am
having is that I set a static reference on sheet 1 cell A1 to say cell
sheet2 cell B1. Whenever I come in the next day I insert a new row
that way row 1 is always where I am pointing my reference from sheet 1
Cell A1. However, When I insert the new row my reference on sheet 1
now become sheet 1 A2. I have tried adding the $A$1 static identifier
to the reference, however, it still dynamically updates. Is there a
way to create this reference without the reference dynamically updating
whever I insert a new row in sheet 2.
 
Back
Top