Marcus
Marcus
Getting Data from a Website in JSON format using VBA
One increasingly common task for Excel users is to retrieve data from the internet.
Simply, retrieving data from the web is the first challenge.
This sounds simple enough (and as you’ll soon see, it is).
But most people run into a roadblock with the second challenge: wrestling with data in JSON format.
Discover the easiest and fastest way to get JSON data into Excel.
Why does excel sometimes get stuck on a group of cells
“Why does excel sometimes get stuck on a group of cells?””Why does excel sometimes get stuck on a group of cells and it’s very hard to get it to click and sit on only one cell at a time?”This was a question I answered on Quora.It’s something which has plagued me in the past, so […]
Continue readingSpeed Up Data Entry in Excel with Prompts
Have you ever created a spreadsheet people used to enter data? A bit like a data entry form, but on a worksheet?You may have wondered how to make the form more intuitive. That way your users knew what they should enter in each field.If that’s the case, this post is for you.Making Data Entry More […]
Continue reading