I have a spreadsheet that is linked to a
stock market data provider to give real-time
data on a 1-minute basis. The data I receive
is constantly overwritten in the same cells.

I would like to "grab" this data and store
it in another set of columns. How do I do this?

For example:

Received data:
........ Col A ............... Col B . Col C
Row 1 .. 3/23/05 9:32:00 AM .. INDU .. 10400.34

Stored data:
........ Col E ............... Col F . Col G
Row 1 .. 3/23/05 9:30:00 AM .. INDU .. 10408.22
Row 2 .. 3/23/05 9:31:00 AM .. INDU .. 10405.16
Row 3 .. 3/23/05 9:32:00 AM .. INDU .. 10400.34

I found the following code snipped in Excel Help..

Sub Worksheet_Change(ByVal Target as Range)
.. Target.Font.ColorIndex = 5
End Sub

.. but I can't figure out how do declare or set
"Target". Any ideas?