This is probably a stupid question, but I can't seem to figure it out.


Say, for example I have the following formula in _Sheet1-Cell_A1_
*=Sheet2!B4*. In sheet2 I have the following Data:
B4: 25
B5: 50
B6: 75
B7: 100

_Sheet1-Cell_A1_ will now show 25. I want to be able to delete row 4
in sheet 2, and have _Sheet1-Cell_A1_ keep the reference to
_Sheet2-Cell_B4_. _Sheet1-Cell_A1_ should now show 50.

This does not work... I keep getting a reference error:
*=Sheet2!#REF!*

Any ideas?
TIA,

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=513409