Here’s a simple handy custom-built function that can help you pull bits of information from web pages right into Excel. The function requires two parameters: the URL and the Xpath to the targeted information on the web page. Xpath is a language that can locate elements on a web page, just like URL locates web […]

Dropdown Selector

If you have to manually enter or adjust date ranges in your form, dashboard, or report, I’m going to show you how to put together date range selectors that can automatically fill in the start and end dates thanks to a few lines of nifty VBA code. First make sure that the cells containing the […]