Need some help please. My excel sheet reads off data from a dynamic webpage that is frequently updated with data. (Web Query)
Basically, orders/deliveries that are scheduled during the day and the updates consist of the whether the order has been fulfilled or not, etc.
At Midnight, a whole new data tables come into place (future scheduled orders for the new day).
However, as we are a night shift team, we need to still use the data from the previous day.
The URL of the webpage is exactly the same when the dates are changed from the menu of the webpage.
Is there any way that I can still utilise the previous days data when the day changes at midnight?
(Note: that my excel sheet has a refresh orders macro which refreshes the sheet to check the webpage if there are any updates)
Any help would be greatly appreciated
Bookmarks