Picking up prev. month's balances

[lrozyczko]

Every month I make a worksheet summarizing the month's
activities. The info comes from a master worksheet in
the same file. I need each new worksheet to go into the
previous month's worksheet to get beginning balances.
For example, October 1 balances=September 30 balances.
November 1 balances = October 31 balances. Each new
worksheet is created by copying the previous month's.
How do I get the beginning balances to be the previous
month's ending balances? It cannot be the specific cell
address of the previous month balances, or when make a
copy for the new month, I'll have the wrong previous
balance. EX: When I make a neww worksheet for October
1, it must pick up Sept 30 balances not Aug 31 that was
used last month.

 

[Bob Phillips]

Can't see the data so I am guessing, but you can get the date of the last
day of the previous month with

=DATE(YEAR(TODAY()),MONTH(TODAY()),0)

 

[Alex Delamain]

Without knowing the layout that's all I can suggest too.

Alternatively for the last day of the previous month you could use

=EOMONTH(TODAY(),-1)

from there you should be able to do some form of lookup to get th
closing balanc

 

[Bob Phillips]

even blind, we try to see <vbg>


Bob