Absolute cell reference question
 

I am trying to develop a form so that I can pull the value of one specific
cell (source cell) onto a summary sheet. Normally that would be easy.
However, I need to insert a new row in the form every time I make a new entry
on it. When I do that the "source cell" moves down one row so that the
summary sheet ends up with the "old" value from what is now one row down from
its original position. Is there a way to write the reference on the summary
sheet so that it automatically retreives the value in the cell the top row
even after I've inserted a new row?

=index('sheet1'!a:a,1)
or
=indirect("'sheet1'!A1")

Since =indirect() is a volatile function (recalculates with every
recalculation--even though it might not be necessary), the first is better--it
only recalculates when you change something in column A of that sheet1.


Dick L wrote:

I am trying to develop a form so that I can pull the value of one specific
cell (source cell) onto a summary sheet. Normally that would be easy.
However, I need to insert a new row in the form every time I make a new entry
on it. When I do that the "source cell" moves down one row so that the
summary sheet ends up with the "old" value from what is now one row down from
its original position. Is there a way to write the reference on the summary
sheet so that it automatically retreives the value in the cell the top row
even after I've inserted a new row?

--

Dave Peterson