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

--

Rodrigo Ferreira
Regards from Brazil
Sorry for my poor english


"JimVT" escreveu na mensagem
...
I am trying to set up a month-to-month data sheet. Can I set it up so that
the accumulated total from one month carries over to the next?
--
JimVT