Need to scrape and save website table data that is constantly being updated online. Webpage is very simple (just table list with two txt columns) and requires no logins, contains no pics, no links, etc.
Target webpage is constantly updated and replaces old table date with new entries with each reload. We need to save and build a complete list of the posted website information (old data + updated data) on a ongoing basis.
A suggested approach may be using an xls web query (with refresh ~10min) to capture data into worksheet and then copy this with a Macro into a second sheet that stores and saves a list of the complete updated information while running. The idea is that each new refresh list of web query data automatically gets added and saved below the previous in the second xls worksheet.
Looking for a Freelancer who can provide this solution using xls concept above (or any other efficient method/program) to accomplish the objective. Have seen partial solutions and variations of this task online in excel forums, but we are not familiar enough with VBA to adapt the requirements for our purposes.