Imo, the simplest is still to re-define "Expenses" as a dynamic range
In xl2003, I'd just click Insert Name Define
select the name: Expenses
and overwrite whatever's within the "Refers to" box with say, this:
=OFFSET(Sheet2!$A$2,,,COUNTA(Sheet2!$A$2:$A$200))
Then just click OK, and I'm done.
The above will make Expenses a dynamic range which will shrink or expand as
items are deleted/added. The items' range is assumed continuous from A2 down,
w/o any blank cells in between.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---