Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 24th 12, 04:54 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Default 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.

  #2   Report Post  
Old May 24th 12, 07:15 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by matt_writer View Post
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.
  #3   Report Post  
Old May 24th 12, 08:26 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Default

Quote:
Originally Posted by Spencer101 View Post
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.
I did give an example. Sorry if you are confused, I thought I explained it well enough for someone one to understand what I am trying to do. On the first sheet, column A is the date, column B is the description of transaction, column C is what I credit to my account, column D is what I debit from my account, and column E is my running balance. In sheets 2 and 3, (they are sub accounts that are drawn from the first sheet), I want to be able to enter in the data only in sheets 2 or 3 and have sheet 1 auto populate to reflect the transaction I did in sheet 2 or 3. Sheets 2 and 3 are set up just like sheet 1. Does that make more sense? But all I want to populate is the date, description, and whether it was a debit or a credit into sheet 1.
  #4   Report Post  
Old May 24th 12, 09:22 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto populate cell with info on other cell (Sheet) Oscar Excel Worksheet Functions 4 February 3rd 09 03:35 PM
Auto-populate, Auto-copy or Auto-fill? Jay S. Excel Worksheet Functions 4 August 10th 07 09:04 PM
can I auto-populate cells on another sheet? [email protected] Setting up and Configuration of Excel 1 March 5th 07 07:41 PM
can I auto-populate cells on another sheet? Echo Excel Discussion (Misc queries) 2 March 5th 07 06:27 PM
Auto Populate sheet name of active workbook in Combobox in Command Bhavtosh Excel Programming 2 January 24th 05 09:03 AM


All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017