2
I have a list of values that updates as new data becomes available on a website using importXML (cells A1-A25). I want to store those values elsewhere in the spreadsheet so that when the values update I have the new values and the old values.
Currently when the values update I lose the old values. What is the easiest way to do this in google spreadsheets? (or in excel if not possible in google spreadsheets)