I hope i have understood your question. if you think the balance amount will
always be in the second row youcan freeze the first two rows.
highlight the third row and freeze pane




"rsilver" wrote in message
...
Hi!

I am trying to set up a worksheet where I have different columns for each
area in a budget (ie "Food", "entertainment", "security", etc)

Column A&B = Date and decription of each item
Row 1: Budget areas listed above

Now I have done the "freeze frame" command so that no matter where I
scroll,
I ca always see Row #1. I would like to have a running balance for each
column that I could also see no matter where in the worksheet I am.

For Example, C1 = "Food"
C2 = a running balance for how much is left in the food budget
C3 - C(really big number) would be where I enter money spent on food, or
donations to the food budget, and C2 would automatically update to tell me
the current balance

I hope I explained this okay. I'm not married to the idea of setting it up
exactly like this, if there is a better way. I just want to be able to
have a
running balance for each budget area that I can easily see without having
to
scroll all over the place.

Thanks in advance!