This is a simpler version to follow, I really hope somebody can help me...

I have a worksheet change event in my sheet one code that calls all of my subs each time there is a change to any of the cells. Once Sub MatchedMoneyTest () gets called I think I need something like the following to happen:

Sub MatchedMoneyTest ()
‘establish a range of 30 seconds (Using Cell C4 as a reference to note when a second has passed)

‘Every time an even cell between K10:K20 increases the increased amount is added to the corresponding last traded price (Just like the orange and pink column in the picture from the previous but-one post) – This information will appear in the column AQ for changes in K10, AR for changes in K12 etc

‘The value time decays each second as it passes through the 30 second range so most recent figures have a weight of 30/465, a second later it’s weighting is 29/465, the second later 28/465 etc.

End Sub