Hi Ryan, This seems interesting... and this can be done... i can do this for you...
just an advise, do you really want to have one sheet for each account, or will it be better to keep all the transactions in on sheet (that will be the database) and then have a sheet than can pull transaction of each account... whats your thoughts Nishant On Jun 7, 8:36 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Ryan, > > Did you tried templates on Microsoft website? Here is the link, plz > reply with your feedback. > > http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZXL > > Here you'll find templates on > Receipts > Invoices > Budget > Inventories > and Expense reports etc. > > --------------------------------------------- > Regards > Ashish Jainhttp://www.excelitems.comhttp://www.openexcel.com > *Developer of Open XL* > --------------------------------------------- > > On Jun 6, 11:51 am, spazlon <spaz...@gmail.com> wrote: > > > > > Hello, > > > I am looking for a personal finance spreadsheet. I tried making one of > > my own, but quickly realized I lacked the knowledge to do what I > > wanted. Basically I want to have one sheet that will have all of my > > transactions on it with a Debit and Credit column. I will also have a > > sheet for each of my accounts. When I add a transaction to my main > > sheet, I want it to reflect in the corresponding account sheets. > > > For example, if I debit $100 from Checking and credit Savings, I want > > that row to appear on the Checking and Savings sheets as well. > > > Does anybody have a sheet that will do this? > > > Thanks! > > > - Ryan --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---