VBA Formula Help
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
| Attachment | Size |
|---|---|
| Please Help with VBA code.xlsm | 21.79 KB |
»
- Danno's blog
- Login or register to post comments
- 2963 reads
take a look
take a look here:
http://excelexperts.com/VBA-Tips-Run-Code-Every-Hour-Minute-or-Second
for a bespoke solution, pls request a quote:
http://excelexperts.com/contact
Help on VBA Code to copy streaming data
Nick,
Thanks for the tip, this sheet is very close to the soulution. The only thing that is realy missing is pasting the infomation only if it exceedes a value >cell(5000)and pasting special values each time moving one cell to the right, which would give me a record of all trades over a specific number. I'll keep hacking and trying to get it right.
Thanks again