M
matt_writer
I have set up my finances using excel 2010. My first sheet is my balanc
sheet, and I have 7 or 8 other sheets that are sub accounts. Is there
way I can auto populate my balance sheet in sheet 1 by inputting dat
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 dat
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 th
balance
sheet, and I have 7 or 8 other sheets that are sub accounts. Is there
way I can auto populate my balance sheet in sheet 1 by inputting dat
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 dat
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 th
balance