+ Reply to Thread
Results 1 to 3 of 3

Copy data into new cells on a time schedule

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    4

    Copy data into new cells on a time schedule

    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!

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copy data into new cells on a time schedule

    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.

  3. #3
    Registered User
    Join Date
    06-28-2013
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Copy data into new cells on a time schedule

    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
    Attached Files Attached Files
    Last edited by BCrawford; 07-28-2013 at 10:28 PM. Reason: attached spreadsheet

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Needing to combine 2 IF statements in one Cell. Time Schedule minus lunch time
    By cody_o in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2013, 04:10 PM
  2. Employee Schedule - Copy over data in different format
    By jpecor2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2013, 11:58 AM
  3. [SOLVED] #value to 0 with schedule using start time end time
    By flapjack1803 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 04:37 PM
  4. [SOLVED] VBA to Copy set data, paste into set cells, then copy more & set into cells related 2 date
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 99
    Last Post: 02-01-2013, 08:43 AM
  5. [SOLVED] How to use solver to schedule part time and full time workforce?
    By The Ooz in forum Excel General
    Replies: 0
    Last Post: 08-18-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1