Copy from one excel file to another
 

Is it possible to copy the information in a cell from one file to another?
This is for a situation in which when a cell in one file is updated, the
information also transfers to another excel file.

Copy from one excel file to another
 

Excel doesn't "push" the data between cells--but you could use a formula to
"pull" the value from any other cell.

Open both workbooks
Select the cell whose value you want to retrieve
edit|copy

Select the cell that will get that value
edit|paste special|click Paste Link.

When you close the "sending" workbook, excel will adjust the formula to include
the drive and path.

This is a one way street--and only the value is retrieved--not the format.

Gus wrote:

Is it possible to copy the information in a cell from one file to another?
This is for a situation in which when a cell in one file is updated, the
information also transfers to another excel file.

--

Dave Peterson