+ Reply to Thread
Results 1 to 2 of 2

copy hourly updated values to new rows

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    England
    MS-Off Ver
    2007
    Posts
    3

    copy hourly updated values to new rows

    Hello, I feel this has a simple solution but I can't wrap my head around it.

    So far sheet1 lists all the foreign exchange rates (provided by msn money) and updates every hour.

    What I am trying to do is copy all the exchange rate values to a row in sheet2 and with every hourly update copy the new values to a row below.
    thus creating a list of the exchange rates, hour by hour, automatically.

    Any help would be greatly appreciated.

    Thanks

    EddyC

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: copy hourly updated values to new rows

    You need to use the ontime function.

    I am attaching a working example.

    This causes a macro to run every second. You can see by the timer.

    Modify it to run your code every hour.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 10-09-2014 at 06:17 PM.

+ 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. Replies: 1
    Last Post: 05-26-2014, 09:22 AM
  2. [SOLVED] Copy Column A reference number values only for updated rows
    By SierraKilo78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 10:31 PM
  3. [SOLVED] Average hourly values of the same day (one column with six months of data)
    By Exorbit in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2013, 06:42 AM
  4. [SOLVED] copy paste updated values in real time
    By excelpea in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-03-2012, 11:53 PM
  5. Calculating daily values from hourly
    By Snodrifter in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-06-2012, 11:14 PM

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