Command to update data from one sheet to another

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

igorek

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.
 

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

Command to update data from one sheet to another 6
Filling cells with filtered data to another sheet. 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Lookups - how to obtain data from a master spreadsheet into another 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How to protect & hide Sheet 3
Formula to copy multiple cells onto another sheet 3
If data is on one sheet, linking to another 2

Top