I've been told I need an: "Excel macro to move web query values to another location for long term storage and use" Can anyone offer any insight into how I do this? For example I want to store daily data for FTSE options. Using web queries from Yahoo, my data refreshes, but overwrites the early stuff. On refresh I want the old stuff to go somewhere else and progressively stack up so that I can marvel at it as a graph. Any help greatly appreciated.