Time-Triggered Cell Copy/Paste

**gandolff** · 10-31-2009, 07:15 PM

Hi,

OK, I'm about 90% done w/my project. There is one snag; I need to somehow auto-copy/paste (not auto-concatenate) A1 to B1 and A2 to B2 -- at 7pm every Sunday night!! Can this even be done? I can take it from there, but if this is possible, I'd really appreciate kowing how to do it.

Thanx,
G

**broro183** · 10-31-2009, 08:37 PM

Hi,

If the file/Excel is closed you'll need to Schedule a task - see http://www.excelforum.com/excel-gene...ate-excel.html

If Excel is open, you can use an "OnTime" macro - see below for examples: http://www.ozgrid.com/Excel/run-macro-on-time.htm
http://www.dailydoseofexcel.com/arch...ontime-method/

hth
Rob

**gandolff** · 10-31-2009, 11:47 PM

Thanx, I'll check 'em out!

**gandolff** · 11-01-2009, 01:57 AM

broro183, that's interesting/handy stuff... Only thing, I don't know the code to copy/paste (e.g., "A1 to B1 & A2 to B2" -- I was a philosophy major, lol.)

**broro183** · 11-01-2009, 06:37 AM

hi Gandollf,

To find out what the code is, you can record a macro of your actions by pressing [alt + T + M + R], give the macro a name (with no spaces) & choose "this workbook" as the location, [ok], complete the copy & paste manually, stop recording by re-pressing [alt + T + M + R]. Press [alt + F11] to open the VBE (Visual Basic Editor), expand the project for your file & you'll find the code in the module folder (probably as "module1").
This use of the macro approach is a very good way to learn/create code for many/most of the actions in Excel. However, the recorder will also record extra actions as you'll see if you compare your recorded code with the below (nb sheet names may need to be changed):

Please Login or Register  to view this content.

To help you learn more about macros, have a read of: www.mvps.org/dmcritchie/excel/getstarted.htm

hth
Rob

**royUK** · 11-01-2009, 07:04 AM

Seems like you don't mind using our Forum for FREE HELP, but you can't be bothered to follow the Forum Rules.

You have previous Moderator warnings in other posts such as here. I suggest you Go back & make right what you have been asked to do. PM me when you have & I will re-open this thread.

DO NOT OPEN ANY MORE QUESTIONS UNTIL YOU HAVE DONE THIS