K
klat7292
I am trying to correspond a running balance on a sheet to correspond to a
master sheet of totals. I am creating a budget workbook in Excel 2003 with
the feel of envelope budgeting where I create multiple "envelopes" (using a
check book register template) and I distribute monies from income throughout
these "envelopes". As I spend money, I enter these transactions on the
appropriate envelope sheet and MAIN checking acct sheet, but I also have a
MASTER BUDGET SHEET at the beginning of the workbook that I would like all
corresponding running envelope balances to reflect as I make
transactions...So far I have managed to create functions for the MASTER
BUDGET SHEET for income in and out, but I am stuck on "seeing the whole
picture" on that sheet with running totals from other sheets...I hope that
there is a way, because I have been doing this on an online software and it
is pretty neat, but I am trying to duplicate it in an Excel spreadsheet to
cut costs of membership. Great program, but it does have its flaws, so I am
trying to take matters into my own hands, so to speak...
Please help!! I am soo close!! I know that Excel 2003 is capable of doing
this!!
master sheet of totals. I am creating a budget workbook in Excel 2003 with
the feel of envelope budgeting where I create multiple "envelopes" (using a
check book register template) and I distribute monies from income throughout
these "envelopes". As I spend money, I enter these transactions on the
appropriate envelope sheet and MAIN checking acct sheet, but I also have a
MASTER BUDGET SHEET at the beginning of the workbook that I would like all
corresponding running envelope balances to reflect as I make
transactions...So far I have managed to create functions for the MASTER
BUDGET SHEET for income in and out, but I am stuck on "seeing the whole
picture" on that sheet with running totals from other sheets...I hope that
there is a way, because I have been doing this on an online software and it
is pretty neat, but I am trying to duplicate it in an Excel spreadsheet to
cut costs of membership. Great program, but it does have its flaws, so I am
trying to take matters into my own hands, so to speak...
Please help!! I am soo close!! I know that Excel 2003 is capable of doing
this!!