Worksheet DESIGN - Prev. Balance

[Neon520]

Hi Everyone,

I have a small problem with the design of my worksheet about "Previous
Balance"
Here is the set up:

ROW1| | |Previous Bal.| $$$| <<< let's say: $25.00
ROW2|Date|Fee|Unit |Bal. |
ROW3|01/01/08|$2.00|5.00|=$10.00+$25.00(prev. bal.)|
ROW4|01/02/08|$3.00|3.00|=$9.00+$35.00(the row above)|

The problem I'm having is when I enable autofilter feature in Excel and
since the formula for the first row (01/01/08) need to pick up the Prev.
Balance from ROW1 and skip ROW2 as the header row, but the rest of the
formula need to pick up the balance in the row above it. When I do a sorting
in AutoFilter, the Formula will always mess up.

Can anyone suggest a different design, maybe, to avoid this sorting dilemma
with the formula?
Hope I explain myself correct. Thanks in advance.

Neon520

 

[Leith Ross]

Hello Neon520,

Create another column an label it "Opening Balance". Use the value of
this column for the value of the first formula. Use the "Previous
Balance" for the remaining formulas.

Sincerely,
Leith Ross