It is generally considered bad form to post your question in the Subject of
a post and not in the body of the post. The subject should name the topic to
which the question applies (e.g., "Trouble With Array Formulas") and the
body of the post should state the question in detail, including what you
have tried, what results you have received, and the results you want to get.
This is particularly important since subject lines are limited in length,
and yours was truncated, so your whole question isn't available.

That said, I'm going to guess that the ending "ti" in the subject should
have been "time". The basic code to transfer the data from one sheet to
another is

Worksheets("Sheet1").Range("C1:D10).Copy
Destination:=Worksheets("Sheet2").Range("A1")

To do this at a scheduled time, you need to use the Application.OnTime
method. See www.cpearson.com/Excel/OnTime.aspx for details and example code.
This page also describes how to configure the code so that the procedure
will run periodically, such as every 10 minutes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Carypot" wrote in message
...