I don't have messanger on my work computer Julleanna... sorry. Yes sheet 1
is summary... example: Summary Sheet Column 'E' is the column I need to
have my running totals show up in .... say cell '27E' currently I have in
this cell '=233-Public Awareness'!E5' and that gives me the running total at
the point of one transaction from that budget line... the next transaction
will be on E6 and somehow when I complete my transactions I need the running
balance from that column E to continue to change on the summary sheet 27E..
Does that make any more sense?

"Julleanna" wrote:

IM (messanger) me at . At the bottom of a new workbook you
have "sheet 1" "sheet 2" and "sheet 3". Sheet 1 is your summary page. Sheet 2
and sheet 3 are the ones that will have your running totals.
--
Julleanna


"Katintn" wrote:

Thank for responding Julleanna.... What I have is 1st worksheet is all line
items of an operating budget with beginning budget balance, the following
worksheets are 1 worksheet for each line items where subtractions/additions
will be done throughtout the budget year... the running total column of each
worksheet is what I'm looking to have referenced on the summary page.

"Julleanna" wrote:

If you are totaling all worksheets to the Summary sheet this is the easiest
way to do this. Let's say on sheet 1 your total is in cell E10, sheet 2 total
is E 12.

On the Summary sheet click the cell where you want the total. Enter =sum(
click on sheet 1 cell E10 put the + sign, than click sheet 2 cell E12 and so
on. When you are done put the ) sign after the last cell than hit enter.

Hope this helped.
--
Julleanna


"Katintn" wrote:

I am working on a budget spreadsheet, with multiple worksheets, I have a
Summary sheet in front and need to keep the Summary totals to be the running
balance from each of the other worksheets... How do I formulate that to
pickup each cell each time a running balance cell changes?

THANKS