Linking templates together

[capnhud]

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?

[SteveW]

On Mon, 10 Jul 2006 13:16:02 +0100, capnhud =

<capnhud@discussions.microsoft.com> wrote:

> 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 t=
o
> 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.=



-- =

Steve (3)

[capnhud]

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.


"SteveW" wrote:

> On Mon, 10 Jul 2006 13:16:02 +0100, capnhud
> <capnhud@discussions.microsoft.com> wrote:
>
> > 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?
>
> 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.
>
>
> --
> Steve (3)
>

[SteveW]

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 =3D, switch to the Income sheet click on =
A20
Press enter.

You'll see the cells contains something like
=3D[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 t=
he =

Income file.

Steve


On Mon, 10 Jul 2006 16:11:02 +0100, capnhud =

<capnhud@discussions.microsoft.com> wrote:

> 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 the=
y =

> work
> together as a whole. Instead of having to enter data separately in ea=
ch =

> one.
>
> "SteveW" wrote:
>
>> On Mon, 10 Jul 2006 13:16:02 +0100, capnhud
>> <capnhud@discussions.microsoft.com> wrote:
>>
>> > I was wondering how do I go about linking the numbers in various ex=
cel
>> > templates together so that a change in one template will be reflect=
ed =

>> in
>> > another.
>> > Ex. I have a income statement template and a balance sheet templat=
e, =

>> if
>> > I
>> > make a change to the income statement I would like the balance shee=
t =

>> 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 referenc=
es.
>>
>>