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
|