Is it possible at all?

[bakunet]

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:

[snb]

crossposted at:

http://www.thecodecage.com/forumz/sh...51&postcount=1

[SamT]

What is multiposting?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target Is Range("B2") Then Range("C1").End(xlDown).Offset(1) = Target
End Sub