Hi,

try to use Indirect and Address embeded, use an auxiliar cell to type the
last month eg. March (assuming this auxiliar cell is F3)

so: =indirect(address(7,13,1,1,$F$3))

when
7 = line
13 = M column (13th column)
1 = absolute or relatvie (could be 1, 2, 3 or 4)
1 = A1 or R1C1
$F$3 = March
=March!M7

hth
regards from Brazil
Marcelo




"axialtilt" escreveu:


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