That's great Gary and exactly what i am looking for.  However i am have
one difficulty doing this.

i click on the cell named "EXPENSE_TOTAL", got to menu
Insert->Name->Define.  Find the EXPENSE_TOTAL name, remove the "$" has
you suggested and then click ok.  However, when i do this, the name is
no longer associated with that cell and it does not seem as though i
can reassociate it with that cell.

Any suggetions?

-----------------------------------------------------------------------------------------------------------
From:  GS - view profile
Date:  Sat, Jun 24 2006 12:58 pm
Email:   GS <G...@discussions.microsoft.com>
Groups:   microsoft.public.excel.programming

Hi farseer,

You could make your defined names column-relative so they refer to
absolute
rows only. This will allow copying the formula(s) across other columns
(ie.
fill across) and have them refer absolutely to the rows in their
respective
column containing the formula(s).  For example:

  If the RefersTo box shows:   =Sheet1!$A$2:$A$8

  change it (remove the  $  before the column) to show as:
=Sheet1!A$2:A$8

Now the formula will refer to rows 2 to 8 of the column containing the
formula.  This assumes the rows alloted to each section are constant
across
the sheet. For example, if you copy the formula(s) to column D, the
respective .RefersTo will be:

  =Sheet1!D$2:D$8
and..,
selecting the name in the name dropdown will select cells of rows 2 to
8 in
whichever column the active cell is currently located.

HTH
Regards,
Garry