In excel, A1 contains a num value that changes every minute, How can I capture value of A1 in cell B1 at exactly 6:30 PM. I may use if function, however, the value of B1 shud not get updated along with time. It shud always contain the value of A1 at6:30pm
-
-
Answer:
How is the worksheet activated, recalculated, or added to so that it is updated "every minute"? That is not normal behavior for an Excel file, so that's a key to whatever else we're trying to do here.
kalyan at Answerbag.com Visit the source
Other answers
... I'll give you a hint without writing the code for you ... ... you have to have a near endless loop that checks the system clock and compares it to 6:30 PM ... if/when equal, then copy the value from A1 ... if/else while not equal, loop and check the clock again, compare again, and so on, looping until it does equal ... then "save as" so the file is copied and named with the name being the time/date ... this will give you a new file every day with the value of A1 at 6:30 PM stored in cell B1 ...
Takei-Shihan
Related Q & A:
- How can I use real time social data from Datasift and perform real time analytics on it?Best solution by Quora
- How can I capture the raw audio stream on an android device?Best solution by stackoverflow.com
- How can I get a picture from my email to my cell phone?Best solution by Yahoo! Answers
- How can I record my xbox without a capture card?Best solution by ChaCha
- How can I block a number on my cell phone?Best solution by eHow old
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.