Linking templates together capnhud 10.07.2006 12:16:02 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?

Re: Linking templates together SteveW <sj_walton[ at ]nothotmail.com> 10.07.2006 13:19:34 On Mon, 10 Jul 2006 13:16:02 +0100, capnhud = <capnhud[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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)

Re: Linking templates together capnhud 10.07.2006 15:11:02 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: [Quoted Text] > On Mon, 10 Jul 2006 13:16:02 +0100, capnhud > <capnhud[ at ]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) >

Re: Linking templates together SteveW <sj_walton[ at ]nothotmail.com> 10.07.2006 16:24:57 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[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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[ at ]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. >> >>