#1   Report Post  
Old September 30th 05, 04:33 PM
Bobby B
 
Posts: n/a
Default Help w/Excel Worksheet

I'd like to create a simple s/s to add deposits and deduct sums as like a
checkbook register and keep a running balance..say in differant columns.
Help with that.
Thanks.


  #2   Report Post  
Old September 30th 05, 06:05 PM
holy dog
 
Posts: n/a
Default

MS Money would be a better program for that.

"Bobby B" wrote:

I'd like to create a simple s/s to add deposits and deduct sums as like a
checkbook register and keep a running balance..say in differant columns.
Help with that.
Thanks.

  #3   Report Post  
Old September 30th 05, 06:46 PM
David McRitchie
 
Posts: n/a
Default

Hi Bobby,
See Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
for an example of a checkbook layout and a macro to insert row(s)
above the active cell. Use of OFFSET Worksheet Function
so that you can insert/delete/sort rows without causing havoc.

I have Quicken myself, and like "holydog" . I'm no longer keeping a separate
worksheet with my checks, I converted my Excel worksheet a long time ago
to Quicken and maintained both, but I only use Quicken now.

I have stocks which are difficult to keep track of without such a package
and you update from your bank. But if all you have is checking account
I doubt that it would be worth the money to buy such a package just fto keep
track of your checking account. If fact if you forget to write the check in
your checkbook and want to update your file (Excel, or Financial package)
you can see a check image online.

On the otherhand if you own any stocks, you'd best have software
such as Quicken or MS Money, and then you can update the files on
your computer by accessing daily stock quotes and your financial
institutions.(including your bank).

Actually I guess the main reason I no longer keep a separate record is
that many of my transactions are with a debit card, or paying bills online
so most all of the checking account entries no longer involve checks.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"holy dog" wrote in message ...
MS Money would be a better program for that.

"Bobby B" wrote:

I'd like to create a simple s/s to add deposits and deduct sums as like a
checkbook register and keep a running balance..say in differant columns.
Help with that.
Thanks.




  #4   Report Post  
Old September 30th 05, 07:01 PM
holy dog
 
Posts: n/a
Default

I don't have stocks, but Money works well with my online banking, my check
card purchases, on-line pay bill and mostly with importing my statements from
my bank. I find this easier then trying to maintain it in Excel, I too
converted mine years ago.My wife uses Quickbook for her business, but that is
another story.

"David McRitchie" wrote:

Hi Bobby,
See Insert a Row using a Macro to maintain formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
for an example of a checkbook layout and a macro to insert row(s)
above the active cell. Use of OFFSET Worksheet Function
so that you can insert/delete/sort rows without causing havoc.

I have Quicken myself, and like "holydog" . I'm no longer keeping a separate
worksheet with my checks, I converted my Excel worksheet a long time ago
to Quicken and maintained both, but I only use Quicken now.

I have stocks which are difficult to keep track of without such a package
and you update from your bank. But if all you have is checking account
I doubt that it would be worth the money to buy such a package just fto keep
track of your checking account. If fact if you forget to write the check in
your checkbook and want to update your file (Excel, or Financial package)
you can see a check image online.

On the otherhand if you own any stocks, you'd best have software
such as Quicken or MS Money, and then you can update the files on
your computer by accessing daily stock quotes and your financial
institutions.(including your bank).

Actually I guess the main reason I no longer keep a separate record is
that many of my transactions are with a debit card, or paying bills online
so most all of the checking account entries no longer involve checks.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"holy dog" wrote in message ...
MS Money would be a better program for that.

"Bobby B" wrote:

I'd like to create a simple s/s to add deposits and deduct sums as like a
checkbook register and keep a running balance..say in differant columns.
Help with that.
Thanks.







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
help! making a worksheet more automated? redb Excel Discussion (Misc queries) 2 April 15th 05 01:53 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 04:07 PM


All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017