Web Query Updates

[vRant]

Hello I'm currently using web queries to track certain values that update daily. I have it auto-updating daily but I'm wondering if it's possible that every time it updates the new value will go into a new row in the column while the old value remains the same. Also is there another way other than using a VB macro to automatically change a letter to a numerical value? i.e 5.3k to 5300? -Thank you.

 

[jasonb75]

Welcome to the board!

Not sure about the web query impoting to a new column each time, I think the refresh would have to be linked to the original range so it could be a bit messy.

The way I would do it is to run the query on sheet 1, then copy the date to the next empty row / column in another sheet.

Converting, possible, but I would say the macro is more practical for this.