Save old data when refreshing web data

[hansen]

Hello everyone,

I was wondering if the data being pulled by excel from the web, could be saved before refreshing it every minute.

Looking around I got this macro which saves the new data in c3 to c4 and moves the existing cells with data one cell lower. I used a dynamic named range for this as well.

This macro works great manually.

Need help to figure out how to run it through an if function only IF there is a change in value. Something like If C4 <> C3 then....

But for some reason the macro would not run through if function and I cannot figure out why.

Have attached the file here. Any help would be appreciated.

Thanks a lot.