Checkbook Formula

  • Thread starter Thread starter J Hatz
  • Start date Start date
J

J Hatz

Hello,

I am trying to set up a checkbook register on my computer with excel. I
don't have any experience with excel and formulas and was wondering if
someone could help me.

I have a column for withdraw (subtraction) and deposits (addition) but in
the balance column, I want it to differentiate between the addition and
subtraction column is that makes sense.

Any help is appreciated.

Thank you in advance,

J Hatz
 
That is what I needed. Thank you so much. Saves me the long way of
programming it myself. Thank you!
 
I was unable to complete the download and test example from the Microsoft
site last night; whereas, I see the poster succeeded and was happy with the
result. Anyway you might take a look at an example of a check register in
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
The main point is that it allows you to insert and delete rows between
rows at a later time as well as at the bottom. This is not a template.
The use of OFFSET is critical to this ability.
 
You're welcome, and the feedback is appreciated

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Back
Top