Linking templates together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering how do I go about linking the numbers in various excel
templates together so that a change in one template will be reflected in
another.
Ex. I have a income statement template and a balance sheet template, if I
make a change to the income statement I would like the balance sheet to
reflect the change automatically. How is this possible?
 
I was wondering how do I go about linking the numbers in various excel
templates together so that a change in one template will be reflected in
another.
Ex. I have a income statement template and a balance sheet template, if
I
make a change to the income statement I would like the balance sheet to
reflect the change automatically. How is this possible?
Click to expand...

do mean template ?

Anyway best approach might be for both the income and balance sheet
templates to obtain thier initial values from a common file, ie data.xls

The templates can access cells in this just like normal cell references.
 
I guess I am confused by what you mean. I did not make the templates, but
would like to modify these and other templates that I have so that they work
together as a whole. Instead of having to enter data separately in each one.
 
I'll guess that you mean workbooks then rather than templates

Cells can reference other workbooks just as easily as other cells in the
same sheet

So if the values in the Income sheet produce a balance figure, say A20
then the Balance sheet an refer to this.
Open both files

Click on cell in Balance, type =, switch to the Income sheet click on A20
Press enter.

You'll see the cells contains something like
=[income.xls]sheet1!$a$20

When the files are saved the full file spec will be added.

Now whenever you open Balance you will have the latest sum as found in the
Income file.

Steve
 
Back
Top