Can I send data from one excel sheet to another at a designated ti

C

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Value from one sheet paste under same value on other sheet. 7
HELP PLEASE: Populate multiple excel rows in access at the same ti 2
Help with copying a sheet from One workbook to another workbook 1
Somewhat complex code to copy data from one sheet to another 9
Excel 2010 Sendmail .Display works, but not .Send --- Please help 2
Copy data from one sheet to another 0
Move lines from one sheet to another 2
Copy data from one sheet to another 2

Top