Copy from one excel file to another

G

Guest

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cannot paste from one Excel file to another Excel file 2
How do i transfer information from one excel file to another excel 1
copying data validation to another workbook 3
Copy data from unlocked cells 3
Use Macro to Copy Formula from one Workbook to another 4
Copy a worksheet from one file to another 1
COPY EXCEL 2007 9

Top