 |
 | 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 / February 2005a checkbook register for actual and bank balance current
Hi all, Can anyone point me in the direction of a simple checkbook register that can also show actual as well as current bank balances? I found a nice one on the ms templete in personal finance and love it but I do not know how to insert a colum to calculate current bank balance before items clear. shezageek, I have one, if you would like to take a look at it let me know an I will send you a copy  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 > Hi all, > > Can anyone point me in the direction of a simple checkbook register that can > also show actual as well as current bank balances? I found a nice one on the > ms templete in personal finance and love it but I do not know how to insert > a colum to calculate current bank balance before items clear. Paul, I would be grateful. I use my current one to sync with my pocket pc so I didn't want something that would get too too complicated, but would really like to have that bank balance line added so I could stay ontop of what is running through the bank when. Thanks again and look forward to trying it out. Can you attach it to your next post? Best Regards, shezageek > shezageek, I have one, if you would like to take a look at it let me know > an [quoted text clipped - 9 lines] > insert >> a colum to calculate current bank balance before items clear. shezageek, send me and e-mail and I will send it to you, remove the nospam from the address paul_b@surfbestnospam.net there is an underscore between l_b 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 > Paul, > [quoted text clipped - 20 lines] > > insert > >> a colum to calculate current bank balance before items clear. It has been sent! > shezageek, send me and e-mail and I will send it to you, remove the nospam > from the address [quoted text clipped - 28 lines] >> > insert >> >> a colum to calculate current bank balance before items clear. I have sent you the file 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 > It has been sent! > [quoted text clipped - 30 lines] > >> > insert > >> >> a colum to calculate current bank balance before items clear. Hi Paul, When you get to the end of the check book you have instructions to drag down. Can you please explain what this means exactly and how to extend the register? Thanks so much. >I have sent you the file > [quoted text clipped - 38 lines] >> >> > insert >> >> >> a colum to calculate current bank balance before items clear. drag down means to select the cell(s) you want>grab the fill handle on the lower right of the rightmost cell and "drag down" SignatureDon Guillett SalesAid Software donaldb@281.com > Hi Paul, > [quoted text clipped - 44 lines] > >> >> > insert > >> >> >> a colum to calculate current bank balance before items clear. ok Don, didn't realize there was a fill handle. next question it gives me the options to copy or fill formatting or without. However nothing happens when I select any of those options...the sheet remains unchanged. I am extending the check book so I would assume that is the option I want but I must be missing something previous to this. Please advise. > drag down means to select the cell(s) you want>grab the fill handle on the > lower right of the rightmost cell and "drag down" [quoted text clipped - 54 lines] >> >> >> > insert >> >> >> >> a colum to calculate current bank balance before items clear. If you use the options, as I recall, it's AFTER the drag is complete SignatureDon Guillett SalesAid Software donaldb@281.com > ok Don, > [quoted text clipped - 63 lines] > >> >> >> > insert > >> >> >> >> a colum to calculate current bank balance before items clear. Got it. Started playing around with it and by accident discover this as well. Thanks again. > If you use the options, as I recall, it's AFTER the drag is complete > [quoted text clipped - 81 lines] >> >> >> >> > insert >> >> >> >> >> a colum to calculate current bank balance before items clear. glad to help SignatureDon Guillett SalesAid Software donaldb@281.com > Got it. Started playing around with it and by accident discover this as > well. Thanks again. [quoted text clipped - 84 lines] > >> >> >> >> > insert > >> >> >> >> >> a colum to calculate current bank balance before items clear. shezageek, I also have an excel template I use, I put all the entries in to give a balance in one column, then when they are cleared though the bank I put the clearance date in another column to give me the cleared balance in a 'bank balance' column automatically by formula. I would be happy to send a copy. Do send me your email address to barbarahw44@NOSPAMyahoo.co.uk remove the NOSPAM Barbara > Hi all, > [quoted text clipped - 3 lines] > not know how to insert a colum to calculate current bank balance > before items clear. It has been sent! > shezageek, > I also have an excel template I use, I put all the entries in to give a [quoted text clipped - 15 lines] >> not know how to insert a colum to calculate current bank balance >> before items clear. The template has been sent to your email address, enjoy. Barbara > It has been sent! > [quoted text clipped - 17 lines] >>> do not know how to insert a colum to calculate current bank balance >>> before items clear. |
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.