Simon Bisson. Excel's JSON import tools can now load the data, but you're going to have to construct a data transformation to get at the information you want.

You should now click on the Import button at the bottom, and right away Excel will launch a Power Query Editor window. This window is all about giving you the chance to decide how the JSON data ...

In this tutorial, I’ll show you how to insert a data validation control that runs a VBA event procedure. If you’re not familiar with VBA don’t worry. I’ll supply complete instructions, but ...