Want to automatically copy data from A1 to B2-B13 each hour then restart each day.

  • Hello,


    There are a few of modifications required to handle your latest request:


    1. Redesign the Movedata() macro


    2. In cell B10 add formula

    Code
    =Time(Row()-5,0,0)

    ... and copy it down till cell B21


    3. Design the Workbook_Open() macro to handle your start and end times ...


    4. Adjust the formula in cell R22 to get the actual Average

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!