Command to update data from one sheet to another
 

Is there a command to update data from one sheet to another when both sheets
are located in two different places? I have a workbook that needs to be
updated every three hours; the data is located in a work book in another
drive. I was wondering if is even possible to create a button that when
pressed updates the data automatically.

I'm currently using office 2007.
--
Regards
YM

Command to update data from one sheet to another
 

you can create a button that will open the file on the other drive. Set your
settings to update links and you should be ok.



"Yitzhack" wrote:

Is there a command to update data from one sheet to another when both sheets
are located in two different places? I have a workbook that needs to be
updated every three hours; the data is located in a work book in another
drive. I was wondering if is even possible to create a button that when
pressed updates the data automatically.

I'm currently using office 2007.
--
Regards
YM