Hi i'm having a hard time getting this to work. I have live data in say cell A1 and that number will be randomly changing. After 5,10,15 minutes I want to take the number the current A1 and copy it into different cells. So like after 5 mins the current number in A1 will go to A2 and then after 10 the new current in A1 will go to A3. Thank you.
Hello infoo,
Welcome to the Forum.
If the "live" data is entered manually into cell A1, you could try the Code below.
Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi thanks for the help but unfortunately it did not fix the problem. The live data is coming from another program and changing automatically. I tried using a clock and an if statement for when the time difference equals when I want the data recorded it take the value from the box. Unfortunately im having trouble with the clock and taking the current value from the live cell and prevent if from changing. This has been my attempt so far.tests.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks