I am working in a table for making predictions of soccer teams results based on basics statistics.
I know this is a difficult task and I will appreciate any advice.
What I am looking for is a way to select the Teams that I want to update their results (from a lis of 8000!). The teams list is in the worksheet "Countries and teams".
The selected Teams could be displayed in the "Main" worksheet or maybe in the same "Countries and teams" worksheet (using a checkbox, conditional format, or any other method of highlighting the selected teams).
Then the "Update" macro will loop through those selected Teams, taking the Country and the Team parameters to fill the web query URL parameters in the macro (Now I am using a listbox in C1 and E1 to select the Country and the Team manually).
When the first Team data is updated, the macro will analyze the "Has Occurred", "Current Delay" and "Highest Delay" data based on the parameters prefixed in the "Main" Worksheet.
If this Team complies with preset parameters in any of the 3 markets (Market 1, Market 2 and Market 3), then transposes the respective column (or columns) on the sheet "alarms".
The first Team selected is Real Madrid, then click "Update" button. The data is updated and the "Has Occurred", "Current Delay" and "Highest Delay" values in any of the three markets do not match the "Main" preset parameters. Then go to the next Team, and so on until one Team complies with preset parameters and transpose the column(s) to "Alarms" sheet. After that, is the turn of the next team, until all teams selected was analyzed.
when all selected teams was analyzed, if in the next update proccess any of the alarms is outdated (the parameters are not matching with the "Main" worksheet parameters, then this alarm should be deleted).
Sorry for my semi translated english
Thank you All in advance!