Cricket Scores

About

I made an application on excel which extracts the latest cricket scores with just few clicks.

• Initially, when you press the button on the left, it gives the list of all the current and future matches.

• You can choose the desired match. Enter the match ID in the textbox and click refresh to get the latest score.

• Once you enter the match ID, all you need to do is click refresh to get the latest scores.

Tools used

-Free API from CricAPI

-Power Query for Data Extraction

-VBA for Refresh

-Filters, Data Validation & Conditional Formatting