+ Reply to Thread
Results 1 to 1 of 1

Copy a value to another cell every time it is modiefied (every time in another cell)

  1. #1
    Registered User
    Join Date
    06-01-2016
    Location
    Slovenia
    MS-Off Ver
    2010
    Posts
    6

    Copy a value to another cell every time it is modiefied (every time in another cell)

    Hello!

    I have a program, which is connected to excel. Program is showing live scores of a tennis match and live odds in excel. So, every cell shows some information about match (sets, games, points, sever, odds), and because it is live, values in these cells are constantly changing (every point, every 10sec-1min).
    What I would like, is that after every point, every time values changes, I would scrape these values, so I would like to copy these values to another cells,sheet,data. And do the same for every change of result (points of player 1 or points of player 2), but every time to another cells, one below other. I also put pictures to show, how I thought it would be nice to have data.

    I hope you could understand what my problem is, and if it could be done in excel, or should I include some other programs too.

    Thank you for your help!

    MATCH.png
    DATA.png
    Attached Files Attached Files

+ 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. Creating a VBA Code for if cell value ='s and Last Time Cell Update Time Date Stamp
    By Sixto2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2014, 08:31 PM
  2. [SOLVED] I want to automatically update cell comments with time stamp last time cell changed
    By Med_MV in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2013, 02:35 AM
  3. compare time values - current time with time in cell range?
    By wyattea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2013, 11:28 PM
  4. Replies: 4
    Last Post: 08-21-2013, 12:41 PM
  5. Replies: 5
    Last Post: 04-18-2013, 11:31 AM
  6. copy cell value at a certain time
    By Sarangsood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2011, 08:37 AM
  7. How to Copy the value of a cell to another cell everyday at a specific time?
    By bhavin99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2011, 06:18 PM
  8. Macro/function to take cell value at certain time and copy to other cell
    By reinhardn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2009, 11:27 AM

Tags for this Thread

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