LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 28
Default 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.
--
Regards
YM

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command to update data from one sheet to another Yitzhack New Users to Excel 1 June 25th 08 04:35 AM
how to update a worksheet and have data copied to another sheet? tsuriman3 Excel Worksheet Functions 2 January 4th 08 01:34 AM
How can I get data to automatically update using a master sheet? Julia Excel Worksheet Functions 0 July 30th 07 05:58 PM
Update External Data source from Excel sheet Lara Jacobs Excel Discussion (Misc queries) 2 March 28th 06 07:17 AM
update consolidated sheet when data is added to worksheets prmagpie Excel Discussion (Misc queries) 0 March 1st 06 07:35 PM


All times are GMT +1. The time now is 08:34 PM.

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

About Us

"It's about Microsoft Excel"