• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to sample data 1 time and permanently store in a cell without using VBA?

Goldcar400

New Member
I am using an Excel Real Time Function, =RTD(), which will constantly update when another program is active at the same time. RTD will not work without the other program.
I want to grab the end of the day data for storage but the =RTD() function is constantly updating.

2 Questions

1. Without using VBA, how to sample data from using =RTD() function one time and permanently save one time sample in same or another cell without it being overwritten? The Real Time Data function is constantly updating.

2. After 1 time sampled data has been stored in a cell, upon opening spreadsheet even though RTD function is not connected (the other program is not active), the previously captured data can sometimes disappear because it is waiting for an update. How do I prevent the data from disappearing when I open the spreadsheet? Or how to permanently store previously captured data?

Regards
Tony
 

p45cal

Well-Known Member
Select the cell whose value you want to store permanently, right-click on its border, drag to another cell where you want it to be, and as you let go of the right button, choose Copy here as values only.
 

Goldcar400

New Member
Select the cell whose value you want to store permanently, right-click on its border, drag to another cell where you want it to be, and as you let go of the right button, choose Copy here as values only.
--
Thanks p45cal for response

Can I automate the process in a formula? I need to do it across 300 cells. I was thinking about converting it to text with text function.
 
Top