HI All,

a little help here please? I've had a look on the forum and although
found references to similar problems did not manage to find an existing
solution.

I'm thrying to build a spreadsheet that allows me to report monthly
figures by taking last months YTD figure, adding this months sales and
obtaining a new YTD.

I have a sheet for each month.

so far I am using :

='April '!M7+May!M7+June!M7+July!M7..... etc

which does work as I go along, but means that once you add in the new
month's figures the previous months all reflect that as well.

Is there a "last month" function?

In the past I did it manually, editing the reference to "last month"
and giving specific cell locations and changing that specific cell
location in each month. Unfortunately I have hundreds cell locations to
change and it means adding a new customer or product is very time
consuming.

I've also tried using :

=February!L7+M7

and then changing "febraury!" to "march!" using a global find and
replace for each month. This is much quicker but again it is very
difficult to add in new products or customers.


any ideas please?


--
axialtilt
------------------------------------------------------------------------
axialtilt's Profile: http://www.excelforum.com/member.php...o&userid=36694
View this thread: http://www.excelforum.com/showthread...hreadid=564245