controling a .xls from another .xls

[on-a-mission]

does anyone know if it is possible to control one excell file from
another. i.e lets say there are two files:

a.xls

&

b.xls


in "a.xls" cell A1 we input the number "100", is it possible for this
number to automatically be populated in to cell A1 of "b.xls"??? if so
how???

thanks guys

 

[Guest]

In cell A1 of b.xls, put this formula

=[a.xls]Sheet1!$A$1

Vaya con Dios,
Chuck, CABGx3

 

[on-a-mission]

brilliant, thanks, works a treat....