Quote:
Originally Posted by matt_writer
I have set up my finances using excel 2010. My first sheet is my balance sheet, and I have 7 or 8 other sheets that are sub accounts. Is there a way I can auto populate my balance sheet in sheet 1 by inputting data randomly into the other sheets? For example
Sheet 1
Date | Description | Debit | Credit | Balance
Sheet 2
02-17-2012 | Groceries | (Debit 15.13) | Balance 106.35
02-18-2012 | Paycheck | (Credit 125.00) | Balance 131.35
Sheet 3
02-17-2012 | Gas | (Debit 20.00) | Balance 135.00
Is there a function I can put into sheet 1 so that when I enter data into sheet 2 or 3 it auto populates sheet 1? I only want the date, description, and whether its a debit or credit to populate... not the balance.
|
Without a (dummy) example workbook to look at, it's hard to help you out with this one.
IF you could post one I'm sure someone (possibly me) will be more than happy to help.