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

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

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