Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet DESIGN - Prev. Balance
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet DESIGN - Prev. Balance
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 -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44875 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with worksheet design | Excel Discussion (Misc queries) | |||
Balance Forward - Worksheet Set up | Excel Worksheet Functions | |||
How do I set up a running balance worksheet ? | Excel Worksheet Functions | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
How do i get the running balance from one worksheet to another? | Excel Worksheet Functions |