LeeFrankel
New member
- Local time
- Today, 02:04
- Joined
- Mar 7, 2008
- Messages
- 7
Hello to all the experts 
Here goes,
On one side I have a few rows of constantly updating Future-Contracts values, recent data comes into top line, all rows move down, lasst row vanishes.
On the other side I want to have a list of the various contracts and their most recent values.
For simplicity lets assume I am looking at information of one contract only
and want to keep showing its most recent value.
Example:
APR08 data date value data
Dec08 data date value data ...................APR08 [Recent-Value]
APR08 data date value data
The [Value] is allways in the same cell, D3.
Any Idea will be very helpfull and thank you,
Lee
{What I tried doing is: if(A3=K3,D3,....problem...)}
This is when I realized VBA is prolly needed.

Here goes,
On one side I have a few rows of constantly updating Future-Contracts values, recent data comes into top line, all rows move down, lasst row vanishes.
On the other side I want to have a list of the various contracts and their most recent values.
For simplicity lets assume I am looking at information of one contract only
and want to keep showing its most recent value.
Example:
APR08 data date value data
Dec08 data date value data ...................APR08 [Recent-Value]
APR08 data date value data
The [Value] is allways in the same cell, D3.
Any Idea will be very helpfull and thank you,
Lee
{What I tried doing is: if(A3=K3,D3,....problem...)}
This is when I realized VBA is prolly needed.
Last edited: