Copy data into new cells on a time schedule

[BCrawford]

Hi, experts. How would you code the following for an excel macro: copy and paste live pricing data from one cell (A1) at 10am, 1030am, 11am, etc into cells B1, C1, D1, etc. Thanks in advance for your time!

[oeldere]

Read the link below for get better help to your question.

http://www.excelforum.com/the-water-...-question.html

[BCrawford]

Got it. Thanks for taking the time to point me in the right direction. Here's more info this time.

I am using the following code to copy and paste market data from B10 at 10am, 1030am and 11am across one row. But I don't know how to code pasting data into the next available cell (C10, D10, E10). Code below, spreadsheet attached. Thanks!!

Please Login or Register  to view this content.

How do I attach a sample spreadsheet? Pasted below for now.
A B C D E
9 (blank) Live 10am 1030am 11am
10 Price 32.33