![]() |
Spreadsheet like checkbook register
I'd like to create a simple s/s to add deposits and deduct sums as a
checkbbok register and keep a running balance..say in differant columns. Help with that. Thanks. |
Try this:
A B C D E 1 Check# Description Withdrawal Deposit Balance 2 N/A Opening Balance $0.00 $0.00 $100.00 3 001 Bob's BBQ Pit $10.50 $0.00 =E2-C3+D3 Copy the formula in E3 down for as many rows as you need. "Bobby B" wrote: I'd like to create a simple s/s to add deposits and deduct sums as a checkbbok register and keep a running balance..say in differant columns. Help with that. Thanks. |
All times are GMT +1. The time now is 07:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com