Re: Making a check book ledger

From: Wondering Why (none_at_myisp.com)
Date: 12/31/04


Date: Fri, 31 Dec 2004 10:41:55 -0500

Yes. I created that email address just to get your file, so you are the only
one who has written to it and that is the file you sent.

-- 
Steven
There are two secrets to success in life:
    1) Never tell people everything you know
"Paul B" <to_much_spam_to_list@nospam.com> wrote in message 
news:uKeKvn07EHA.2700@TK2MSFTNGP14.phx.gbl...
> Steven, this does not sound like the file I sent you, the one I sent does
> not have any VBA in it, so no "show checkbook
> form" and "sort transaction list" buttons. Did You get the file that I
> sent?
> -- 
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> " Wondering Why" <none@myisp.com> wrote in message
> news:OkUTSuy7EHA.2196@TK2MSFTNGP14.phx.gbl...
>> Ok, please explain to me what the date has to do with the balance? It
> looks
>> very good, but that one puzzles me. I guess I want an explanation of the
>> equation in "I". Also, why does nothing seem to reference i5 and i5 seems
> to
>> reference nothing. What is it for? What is column "b" for? This is really
>> very nice, however, even when I protect the ***, both the "show
> checkbook
>> form" and "sort transaction list" buttons do nothing. What are they
> supposed
>> to do?
>>
>> -- 
>>
>> Steven
>>
>> There are two secrets to success in life:
>>     1) Never tell people everything you know
>> "Paul B" <to_much_spam_to_list@nospam.com> wrote in message
>> news:%231QbGOu7EHA.3376@TK2MSFTNGP12.phx.gbl...
>> > Steven, file has been sent
>> >
>> > -- 
>> > Paul B
>> > Always backup your data before trying something new
>> > Please post any response to the newsgroups so others can benefit from 
>> > it
>> > Feedback on answers is always appreciated!
>> > Using Excel 2002 & 2003
>> >
>> > " Wondering Why" <none@myisp.com> wrote in message
>> > news:%23HkJgRs7EHA.208@TK2MSFTNGP12.phx.gbl...
>> >> Yes, I would appreciate seeing your setup. To avoid spam, I just
> created
>> >> a
>> >> throw away account in hotmail. Please use that. It is "mynewsgrps at
>> > hotmail
>> >> dot com"
>> >>
>> >> -- 
>> >>
>> >> Steven
>> >>
>> >> There are two secrets to success in life:
>> >>     1) Never tell people everything you know
>> >> "Paul B" <to_much_spam_to_list@nospam.com> wrote in message
>> >> news:uAAecHs7EHA.1296@TK2MSFTNGP10.phx.gbl...
>> >> > Steven, here is one way, payments starting in E3, deposits starting
> in
>> > F3,
>> >> > starting balance in G2, put this in G3 and copy down
>> >> > =(IF(OR(E3,F3>0), OFFSET(G3,-1,0)- E3+F3,""))
>> >> > I have a workbook set up for this if you would like to take a look 
>> >> > at
>> >> > it
>> >> > let
>> >> > me know your address and  I will send you a copy, you may also want
> to
>> >> > have
>> >> > a look here http://officeupdate.microsoft.com/templategallery/
>> >> > Microsoft
>> >> > has
>> >> > one but when I tried to find it I got "Error: Access is Denied",
> there
>> >> > site
>> >> > might be down right now
>> >> >
>> >> > -- 
>> >> > Paul B
>> >> > Always backup your data before trying something new
>> >> > Please post any response to the newsgroups so others can benefit 
>> >> > from
>> >> > it
>> >> > Feedback on answers is always appreciated!
>> >> > Using Excel 2002 & 2003
>> >> >
>> >> > " Wondering Why" <none@myisp.com> wrote in message
>> >> > news:unLQutr7EHA.2196@TK2MSFTNGP14.phx.gbl...
>> >> >> I want to set up excel so I have three columns, debits, credits and
>> >> > balance.
>> >> >> How do I make it so that it will add or subtract the amount and 
>> >> >> give
>> >> >> me
>> >> > the
>> >> >> proper balance each time?
>> >> >>
>> >> >> Thank you
>> >> >>
>> >> >> Steven
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>