#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
duffy
 
Posts: n/a
Default IS IT POSSIBLE?

to copy one excel file to other even when is updated the other file will be
automatically updated too?
cheer
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default IS IT POSSIBLE?

Duffy,
you can do it with a formula. With both workbooks open, in the
destination cell type "=" and then change workbook and point to the
cell, which you want copied. When you have pointed to the correct cell
press Enter to commit the formula and return to the cell.

If both workbooks are open changes in the source will be automatically
updated in the destination.
If destination only opens it will display the last saved value and ask
you if you want the link updated.

HTH
Kostis Vezerides

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"