Auto-populate a balance sheet?
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. |
Quote:
IF you could post one I'm sure someone (possibly me) will be more than happy to help. |
Quote:
|
Auto-populate a balance sheet?
See help on "linking"
Basic linking formula.........in A1 of Sheet1 enter =Sheet2!A1 to return those cell contents from Sheet2 back to Sheet1 Gord On Thu, 24 May 2012 15:54:29 +0000, matt_writer wrote: 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. |
All times are GMT +1. The time now is 04:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com