Hi there.
I am coming to you with some issues.

I receive feed of some data that it is refreshed every 1-3s. Feed can be placed in excel cell using some special formula, and it is refreshed automaticly by the software.

Issue 1) Is it possible to save this feed as a number in separate different cell, that it will be not changed anymore with next refreshment of the feed?

Issue 2) Is it possible to make action from issue 1) every (x) seconds in another row, automaticly?

If yes, how to do it?

Thank you in advance for your help.


EDIT: please check image:

Cross post without links. please read http://www.excelguru.ca/content.php?184

http://www.excelguru.ca/forums/showt...ed=1#post24665

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Also cross posted at The Code Cage and VBA Express - Problem is solved - OP did not bother to inform. Thread closed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post