Auto update for monthly balance

**AndyL3** · 05-19-2012, 02:37 PM

Is it feasible to have a formulas to take care these ?
Please see the attached worksheet
TIA

**FDibbins** · 05-19-2012, 03:59 PM

on your Mar sheet, how do you arrive at the values there?

E = 29
E for Peter = 16

perhaps you could revise your workbook to show how you arrive at the values that you have in your summary table?

**AndyL3** · 05-19-2012, 07:36 PM

On Mar sheet
E=29 is the remaining balance from Feb
E for Peter = 16 is again the remaining balance because Peter used 13E in Mar
The remaining balance will also carry over to Apr and so on. Just wants it to do this automatically if possible
Sorry I couldn't make a more clear.

**FDibbins** · 05-19-2012, 08:16 PM

see if the attached gives you what you want?

**AndyL3** · 05-20-2012, 07:06 PM

Thanks for a million. This is exactly what I need.
Now I can expand this sheet to cover all 25 peoples in our group.
Less hastle and less chance for human error.
Thanks again.

**FDibbins** · 05-21-2012, 03:20 PM

glad to help

If this answered your question, please take a moment to mark the thread as "solved", and consider adding the reputation to those that helped (see points 2 & 3) below