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?

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?