software

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

a.xls

amp;

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

thanks guys--
on-a-mission
------------------------------------------------------------------------
on-a-mission's Profile: www.excelforum.com/member.php...oamp;userid=31630
View this thread: www.excelforum.com/showthread...hreadid=513234In cell A1 of b.xls, put this formula

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

Vaya con Dios,
Chuck, CABGx3
quot;on-a-missionquot; wrote:

gt;
gt; does anyone know if it is possible to control one excell file from
gt; another. i.e lets say there are two files:
gt;
gt; a.xls
gt;
gt; amp;
gt;
gt; b.xls
gt;
gt;
gt; in quot;a.xlsquot; cell A1 we input the number quot;100quot;, is it possible for this
gt; number to automatically be populated in to cell A1 of quot;b.xlsquot;??? if so
gt; how???
gt;
gt; thanks guys
gt;
gt;
gt; --
gt; on-a-mission
gt; ------------------------------------------------------------------------
gt; on-a-mission's Profile: www.excelforum.com/member.php...oamp;userid=31630
gt; View this thread: www.excelforum.com/showthread...hreadid=513234
gt;
gt;


brilliant, thanks, works a treat....--
on-a-mission
------------------------------------------------------------------------
on-a-mission's Profile: www.excelforum.com/member.php...oamp;userid=31630
View this thread: www.excelforum.com/showthread...hreadid=513234