"Mal" wrote in message
...
I am trying to build an automated 'year to date' column in a financial
summary worksheet but don't want to have to update the formula each month
(ie
in month 6, sum cells A to F, then in month 7 change the formula to sum
cells
A to G).

If you have a sheet with calendarised figures (ie each month in a separate
column - and it's a very good analysis tool to do that anyway) and a total
in rows for the twelve months, then the YTD is done automatically, because
all future months are blank! No need for any "automation"!


--
Gordon Burgess-Parker
Systems and Management Accounting
www.gbpcomputing.co.uk