Referenceing previous tabs automatically?

[dlcartin]

I have a household budget workbook, that I created, in Excel 2010. There are 14 cells that carry a 'running total' from the previous month(tab). When I create (copy & rename) a new month (tab), I have to go into each of these 14 cells one by one to change the ref month to the previous month so that all 14 totals are accurate. Is there a way to set up a formula (or whatever) to do this automatically for me? I've been trying for several weeks now, without success. Thanks in advance!!!

[shg]

Welcome to the board.

Yes, and it's pretty fundamental to the way Excel is designed to work: Put all the transactions on the same tab.

Then you can filter, pivot, and analyze to your heart's content.

[dlcartin]

While I'm not a newbie to Excel, my knowledge is still on the 'Basic' level. It took me almost two months (2 - 3 hours a day) to set up my budget sheet and several more to get the 'bugs' worked out. (I was using version 2007 at the time, Thanks to my son, I have since acquired 2010) Alas, I, personally, can't see the advantage/use of having my 'Running Totals' on a single tab. Perhaps one day my eyes & mind will be opened further. But, thank you for your reply.