Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I import data in Excel

I am trying to import data from one worksheet into another worksheet at a
certain day and time every week. Example worksheet #1 contains real time data
and every Friday at 5 pm I want the data numbers to be transferred to
worksheet #2. Is it possible to set up a formula for that?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How do I import data in Excel

Not a formula but Chip Pearson shows how to set up a macro that will do the deed
using the OnTime method.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP


On Wed, 20 Jun 2007 10:57:00 -0700, Sporty
wrote:

I am trying to import data from one worksheet into another worksheet at a
certain day and time every week. Example worksheet #1 contains real time data
and every Friday at 5 pm I want the data numbers to be transferred to
worksheet #2. Is it possible to set up a formula for that?


Reply
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
import data into excel Curioushead Excel Discussion (Misc queries) 0 February 21st 07 08:49 PM
import data to excel pacent Excel Discussion (Misc queries) 8 November 12th 06 01:50 PM
import data from .txt to excel Mandeep Dhami Excel Discussion (Misc queries) 6 September 21st 05 01:05 PM
Import data from web to excel Joseph Excel Discussion (Misc queries) 0 August 4th 05 03:22 PM
how to Import data in excel office2003 with data more 65000 rows Abhijit Excel Worksheet Functions 1 May 13th 05 05:12 AM


All times are GMT +1. The time now is 05:22 AM.

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

About Us

"It's about Microsoft Excel"