| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to update a worksheet and have data copied to another sheet? | Excel Worksheet Functions | |||
| How can I get data to automatically update using a master sheet? | Excel Worksheet Functions | |||
| Copy and paste cahrt to new sheet-update data automatically? | Charts and Charting in Excel | |||
| Update External Data source from Excel sheet | Excel Discussion (Misc queries) | |||
| update consolidated sheet when data is added to worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
