Maintain cell references when data is deleted

[JB]

Hello,

I have workbook that has formulae that reference cells in a sheet that
is updated by first deleting all the existing data and then the new
data is input in the exact same configuration. When the old data is
deleted all my formulae go to #ref. Is there a function that will
maintain the reference to the cell even when the old data has been
deleted?

Example

Sheet1 cell B5 formula is =+Sheet2!B14-Sheet2!D14. When sheet 2
data is deleted and replaced with new data Sheet1B5=
Sheet2!#ref-Sheet2!#ref. I would like to maintain the cell references
on sheet 1

Thanks
JBESr

 

[Earl Kiosterud]

JBE,

=INDIRECT("A2")

Earl Kiosterud
mvpearl omitthisword at verizon period net