"Rodrigo Ferreira" wrote in message
...
If your sheet has a name like "Jan07" and the accumulated total of Jan07
is in column 11 (K) and row 1 - K11, you can use something like this in
plan "Feb07":

=INDIRECT(ADDRESS(1,11,4,,TEXT($E11,"MMMYY") ))

Where $E11 is the date like "02/01/2007"

So when you create a new month, the formula will works to retrieve the
accumulated total of previous month


Eh? Why not just keep it SIMPLE? The OP doesn't evan know how to reference a
cell in one worksheet from another....