View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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