Hi everyone, i currently have 5 macros, they refresh my data, macro1 refresh data from sheet1, macro2 refreshes data from sheet2 and so on
untill sheet5, each sheet has its own macro to refresh its own sheets data. So what i need is when macro1 starts, wait one minute before running macro2,
"macro2 finishes", waite one minute before running macro3 ans so on till last macro, then i can start the sequence, or stop it an any time via the buttons.
It is data from the web in excel, i have tried going to table properties but have been unable to refresh all 5 tables at time intervals as explained previously.
Any help here is highly appreciated.
untill sheet5, each sheet has its own macro to refresh its own sheets data. So what i need is when macro1 starts, wait one minute before running macro2,
"macro2 finishes", waite one minute before running macro3 ans so on till last macro, then i can start the sequence, or stop it an any time via the buttons.
It is data from the web in excel, i have tried going to table properties but have been unable to refresh all 5 tables at time intervals as explained previously.
Any help here is highly appreciated.