Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy from VBA form in to excel file | Excel Worksheet Functions | |||
copy EXCEL file to disc | Excel Discussion (Misc queries) | |||
how to copy Excel file on to a web site? | New Users to Excel | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
how can i copy a word file into an excel? | Excel Discussion (Misc queries) |