I would like to track the streaming value in C11 when it is greater than the maximum starting value of E11 "5000"

I need to pasted special values in cells "F11:F-500" tracking each occurrence and value for each time C11 exceeds 5000
Anyone good at writing VBA the file is attached that explains what I am trying to achieve.
Thanks for reading