Hi Guys!
I have a functioning macro that copy pastes the static values of live data from the live data sheet (Sheet), onto a separate sheet (Sheet2) every second. The code is below. For your information, Range("B2:B2195") are stock codes while Range("H2:H2195") are stock quotes.
I would like to record the difference between the stock quotes. This is a simple computation that calculates the difference between a certain cell and the cell above it and records this value onto a separate sheet (Sheet3). This computation is done for every cell in the range H2:H2195.
and so on...
As the copypaste_RECENT macro is executed every second, I would like this macro to be run simultaneously, that is, execute on Sheet3 as the data on Sheet2 is updated.
Thanks in advance!
Jayyunit
Bookmarks