Hello everyone,
I know next to nothing about VBA, so I turn to you for my problem...
I have a web query that auto updates every X minutes, and dumps the results in cell C2, sheet s1.
I would like to keep all of the data to get a history of the changing values. So I would like to have script that copy C2 every time it changes, and paste the value in s2 in column A, for example. A nice addition would be to have a time stamp in the next column...
Thank you very much for your help !
I know next to nothing about VBA, so I turn to you for my problem...
I have a web query that auto updates every X minutes, and dumps the results in cell C2, sheet s1.
I would like to keep all of the data to get a history of the changing values. So I would like to have script that copy C2 every time it changes, and paste the value in s2 in column A, for example. A nice addition would be to have a time stamp in the next column...
Thank you very much for your help !
Last edited: