 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2005Making a check book ledger
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 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  SignaturePaul 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 > 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 [quoted text clipped - 3 lines] > > Steven 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" SignatureSteven There are two secrets to success in life: 1) Never tell people everything you know > Steven, here is one way, payments starting in E3, deposits starting in F3, > starting balance in G2, put this in G3 and copy down [quoted text clipped - 18 lines] >> >> Steven Steven, file has been sent SignaturePaul 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 > 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 [quoted text clipped - 22 lines] > >> > >> Steven 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 sheet, both the "show checkbook form" and "sort transaction list" buttons do nothing. What are they supposed to do? SignatureSteven There are two secrets to success in life: 1) Never tell people everything you know > Steven, file has been sent > [quoted text clipped - 30 lines] >> >> >> >> Steven 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? SignaturePaul 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 > 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 [quoted text clipped - 38 lines] > >> >> > >> >> Steven 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. SignatureSteven There are two secrets to success in life: 1) Never tell people everything you know > 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 [quoted text clipped - 52 lines] >> >> >> >> >> >> Steven Hi Sorry, but I jumped in there and sent you one I created as well. It should have my name on it and iI did put my name on the email. It will not work properly if you protect the sheet. If you have any questions, please email me directly. Ken Well, I was not paying attention and yes, I got yours ken. I do not appreciate you jumping in where not invited. I know you had good intentions, but you still should have posted here first to ask if it was ok to send yours. SignatureSteven There are two secrets to success in life: 1) Never tell people everything you know > Hi > [quoted text clipped - 4 lines] > > Ken Feel free to delete the a-mail. So I take it that you did not get mine? I got a read receipt that it had been delivered. If not let me know and I will send it again. SignaturePaul 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 > Well, I was not paying attention and yes, I got yours ken. I do not > appreciate you jumping in where not invited. I know you had good intentions, [quoted text clipped - 9 lines] > > > > Ken Paul, I did get yours too. Thank you for sending it. I am checking it out to see what I want from it. I appreciate you sending it to me. I am sending you a copy of what I am going to use. SignatureSteven There are two secrets to success in life: 1) Never tell people everything you know > So I take it that you did not get mine? I got a read receipt that it had > been delivered. If not let me know and I will send it again. [quoted text clipped - 15 lines] >> > >> > Ken |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.