Linking templates together

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

capnhud - 10 Jul 2006 13:16 GMT

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?

Reply to this Message

SteveW - 10 Jul 2006 14:19 GMT

> 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
[quoted text clipped - 3 lines]
> make a change to the income statement I would like the balance sheet to
> reflect the change automatically. How is this possible?

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.

Signature

Steve (3)

Reply to this Message

capnhud - 10 Jul 2006 16:11 GMT

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 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
[quoted text clipped - 10 lines]
>
> The templates can access cells in this just like normal cell references.

Reply to this Message

SteveW - 10 Jul 2006 17:24 GMT

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

> I guess I am confused by what you mean. I did not make the templates,
> but
[quoted text clipped - 20 lines]
>>
>> The templates can access cells in this just like normal cell references.

Reply to this Message

Rate this thread: