controling a .xls from another .xls
 

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


--
on-a-mission
------------------------------------------------------------------------
on-a-mission's Profile: http://www.excelforum.com/member.php...o&userid=31630
View this thread: http://www.excelforum.com/showthread...hreadid=513234

controling a .xls from another .xls
 

In cell A1 of b.xls, put this formula

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

Vaya con Dios,
Chuck, CABGx3



"on-a-mission" wrote:


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


--
on-a-mission
------------------------------------------------------------------------
on-a-mission's Profile: http://www.excelforum.com/member.php...o&userid=31630
View this thread: http://www.excelforum.com/showthread...hreadid=513234

controling a .xls from another .xls
 

brilliant, thanks, works a treat....:)


--
on-a-mission
------------------------------------------------------------------------
on-a-mission's Profile: http://www.excelforum.com/member.php...o&userid=31630
View this thread: http://www.excelforum.com/showthread...hreadid=513234