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.