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 |
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 |
All times are GMT +1. The time now is 11:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com