Sorry it took so long to respond. I am in Kuwait and my internet sucks! I think we are talking about the same thing.
I want one main sheet that will be a database for all of my transactions for every account (Checking, Savings, Credit Card, etc.) I would then like to have a sheet for each of those individual accounts which shows the transactions from the database only corresponding to that account (debits and credits). I can upload what I was working on if that would help to get a visual on what I was trying to do. I just wasn't sure how to get the information from the database sheet to the account sheet. Thanks! - Ryan On Sun, Jun 7, 2009 at 16:24, Nishant Jain <nishantjai...@gmail.com> wrote: > > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
