Command to update data from one sheet to another

  • Thread starter Thread starter Yitzhack
  • Start date Start date
Y

Yitzhack

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.
 
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.
 
Back
Top