Is there a way around the fact that you cannot use a relative reference for
the Worksheet?
I want to use the ending balance from June to automatically populate into
the July opening balance. I have a new worksheet for each month. The
formulas copy and update except for the prior worksheet reference. Is there
a way to get the worksheet to look at the one before it to get these figures?
Right now I use =June!E9 for the July beginning balance, but when I copy
the worksheet to make one for August the formula stays =June!E9. I would
like it to update to =July!E9 (or whatever it takes to get that data) without
having to go through and manually change each line item.

Thanks for any input. I have been browsing the questions and answers here
and realize that I knew Office 97 pretty well, but am totally lost in Office
07!