hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
I am using DDE feeds in my Excel workbook in Sheet1 in cell addresses K1, M1 & S1 which gets constantly updated with the latest values.
In Sheet2, in column D (starting with cell address D1), I am able to constantly update with the latest value of K1, whenever a change in value takes place in K1. I am also able to record the time (in column T, starting with T1) when the changes occurs in K1.
At first instance, D1=First value of K1 AND time recorded in T1. When K1 changes (second instance), D1= latest value of K1 (at the second instance) AND time recorded in T1 & D2=previous value of D1 (at first instance) AND T2= previous value of T1 (at first instance). Similarly, when K1 changes again (third instance), D1=latest value of K1 (at third instance) AND time recorded in T1, D2=Second value of D1 (at second instance) AND T2=Second value of T1 (at second instance) & D3=First value of D1 (at first instance) AND T3=First value of T1 (at first instance). And so on the previous value moves down by 1 row & the current value replaces the previous value. I am able to accomplish this using iteration method.
At the LATEST INSTANCE, I ALSO wants to get values from 2 more cells. I.e. when D1 gets the latest changed value of K1 (at the second instance), I want F in F1 & L1 in Sheet2, to get the PREVAILING values from M1 & S1 respectively (from Sheet1). So, whenever K1 is updated (second instance), F1=latest value of M1 AND L1= latest value of S1. Similarly, when K1 is updated again (third instance), F1= latest value of M1 AND L1= latest value of S1. And so on for the fourth instance, fifth instance ……………………………… should continue.
How to accomplish this? I.e. what formula should be punched in cells F1 & L1.
hsandeep
In Sheet2, in column D (starting with cell address D1), I am able to constantly update with the latest value of K1, whenever a change in value takes place in K1. I am also able to record the time (in column T, starting with T1) when the changes occurs in K1.
At first instance, D1=First value of K1 AND time recorded in T1. When K1 changes (second instance), D1= latest value of K1 (at the second instance) AND time recorded in T1 & D2=previous value of D1 (at first instance) AND T2= previous value of T1 (at first instance). Similarly, when K1 changes again (third instance), D1=latest value of K1 (at third instance) AND time recorded in T1, D2=Second value of D1 (at second instance) AND T2=Second value of T1 (at second instance) & D3=First value of D1 (at first instance) AND T3=First value of T1 (at first instance). And so on the previous value moves down by 1 row & the current value replaces the previous value. I am able to accomplish this using iteration method.
At the LATEST INSTANCE, I ALSO wants to get values from 2 more cells. I.e. when D1 gets the latest changed value of K1 (at the second instance), I want F in F1 & L1 in Sheet2, to get the PREVAILING values from M1 & S1 respectively (from Sheet1). So, whenever K1 is updated (second instance), F1=latest value of M1 AND L1= latest value of S1. Similarly, when K1 is updated again (third instance), F1= latest value of M1 AND L1= latest value of S1. And so on for the fourth instance, fifth instance ……………………………… should continue.
How to accomplish this? I.e. what formula should be punched in cells F1 & L1.
hsandeep
