Thread: How do I import data in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
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 With QuoteReply With Quote