I use my spreadsheet to monitor prices on the web.
H12:H24 is my input range.
I start the process by downloading initial prices and they become my starting prices.
Throughout the day I update these prices and input them into the range H12:H24 overwriting the previous ones.
In J12:J24, I wish to show a percentage movement up or down at any given update point which takes into account all the variances that have occurred since the initial downloading.
The number of times I refresh the prices is open, but varies from 1 to 10 times generally.
Could anyone help me with a macro to do this, that I can then incorporate into my existing update macro.
Thankyou in advance.
RJC
ray:
H12:H24 is my input range.
I start the process by downloading initial prices and they become my starting prices.
Throughout the day I update these prices and input them into the range H12:H24 overwriting the previous ones.
In J12:J24, I wish to show a percentage movement up or down at any given update point which takes into account all the variances that have occurred since the initial downloading.
The number of times I refresh the prices is open, but varies from 1 to 10 times generally.
Could anyone help me with a macro to do this, that I can then incorporate into my existing update macro.
Thankyou in advance.
RJC
ray:
