View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DRobidoux
 
Posts: n/a
Default Copy old Data from web query while keeping previous days data

I have a web query that is updated every day. I would like a way to
automatically copy the previous data to another cell before updating the
query. But also need to keep a record of the past data. for example if i
update the query 5 times i need the old data copied each to a different
cells.. basically keeping a log of old data without overwritting the data
each time.