+ Reply to Thread
Results 1 to 2 of 2

Copy and paste values from a range of cells to a target cell based on a countdown clock

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Warks
    MS-Off Ver
    Excel 2013
    Posts
    91

    Copy and paste values from a range of cells to a target cell based on a countdown clock

    The title's probably confusing so I'll try and explain. I've created a worksheet that is connected to some trading software. From that software I'm able to link a countdown clock for a particular market into a cell in Excel, this countdown clock signifies the time remaining until the KO of a football match and counts down until 00:00:00 (which is KO). Using this clock would it be possible at say 10 minute intervals for Excel to copy and paste data from one set of cells to another?

    For example I have the countdown clock in B1. The data I want to copy is in the range AA2:AC21. The destination cell to paste into is V2. The data in AA2:AC21 is updating at 500ms and hence is constantly changing, the paste part needs to just be the static values if that makes sense.

    Not sure if this is possible but thought i'd check it out anyway. Thanks in advance for any advice.

  2. #2
    Registered User
    Join Date
    10-10-2012
    Location
    Warks
    MS-Off Ver
    Excel 2013
    Posts
    91

    Re: Copy and paste values from a range of cells to a target cell based on a countdown cloc

    Bump, does anyone know if this is possible?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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