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!![]()
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!![]()
Read the link below for get better help to your question.
http://www.excelforum.com/the-water-...-question.html
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
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!!
How do I attach a sample spreadsheet? Pasted below for now.![]()
Please Login or Register to view this content.
A B C D E
9 (blank) Live 10am 1030am 11am
10 Price 32.33
Last edited by BCrawford; 07-28-2013 at 10:28 PM. Reason: attached spreadsheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks