I'm going away on holiday for a few weeks soon, and therefore there will be a gap in my data, as I use macros to update my data every day manually running the macro.
Unfortunately, I am not that good with macros. Can someone help me/direct me as to how I would go about creating a macro that does the following:-
At 4.30pm everyday [or every 'x' mins/hours] it retrieves data from a webpage. It then stores this retrieved data in the same format it retrieved it. When the macro updates, the previous data remains, but the newly retrieved data [whether the data itself has changed or not] is placed underneath/to the side of the old data.
EDIT: No problem, figured it out for myself. If anyone would like to know how to autorun macros and/or autorun copy+paste into next empty cell give me a shout.
Unfortunately, I am not that good with macros. Can someone help me/direct me as to how I would go about creating a macro that does the following:-
At 4.30pm everyday [or every 'x' mins/hours] it retrieves data from a webpage. It then stores this retrieved data in the same format it retrieved it. When the macro updates, the previous data remains, but the newly retrieved data [whether the data itself has changed or not] is placed underneath/to the side of the old data.
EDIT: No problem, figured it out for myself. If anyone would like to know how to autorun macros and/or autorun copy+paste into next empty cell give me a shout.
