View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default So frustrated. All I need to do is expand a simple range :(

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
---