I am using Excel’s web data to move a table of values from a website into Excel. My refresh period is every 10 minutes. The issue with refresh for my purposes is it overwrites the old values with the new. I need to preserve the table data taken every 10 minutes (I’ll plot this) so the progression of values matters (not just what the current value is). I'll run this while I'm at work so it must be automated.
Preferably the data would add onto a single worksheet but if it requires a new worksheet with every data dump, that’s okay too.
Does anyone know if Excel Web Data can do this? Or something like it? VBA is out because the HTML is too difficult to navigate (for me) and the table has too many unique fields I would need to call and iterate through.