Save old data when refreshing web data

Originally Posted by 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.

Come on, people. SOmeone may know how this can be done. Everything that is to be done is in the macro. Only one line of code needs to be added. Sincerely appreciate any help.

Thanks.