Originally Posted By: tfabris
Where did you get the WHO data
https://covid19.who.int/

Look underneath the map and there is a link in small blue type "Download Map Data". It will give you a 13,000 row CSV spreadsheet.

Programming the spreadsheet to update automatically is beyond my Excel capabilities. i may be an Excel God among some of my less techie friends because I can do complex formulas, VLookups, conditional formatting etc. (all of which are used in this spreadsheet BTW) but compared to a lot of people (yes, you, Christian!) I'm not even in the rank amateur category.

However, it takes me less than 15 seconds to update the spreadsheet once I have downloaded the CSV file. Open the file, copy it to the clipboard, paste it into cell A3 of the spreadsheet to overwrite the existing data, and its done.

tanstaafl.
_________________________
"There Ain't No Such Thing As A Free Lunch"