Help with a trend macro please

RJC

Active Member
Joined
Jul 29, 2003
Messages
252
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 :pray:
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,882
Messages
5,766,896
Members
425,383
Latest member
IllDo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top