Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
So you’ve found some VBA code on the ‘net that will save you hours and hours of work, but how do you get it into Excel and use it? Often I’ve seen snippets of code posted on sites that won’t work unless you know where to put them in Excel, and how to actually get …
The Developer tab in Excel gives you access to features and tools that help you to write and run macros. It’s not enabled by default so this is what you do to get access to it. Excel 2007 Click the Microsoft Office button (the round button at top left) Click on Excel Options Click Popular …
Real World Scenario One of my customers (thanks Tony) creates invoices in Excel for his clients and at the end of each month he wants to email these invoices to each of those clients. Each invoice is on a separate worksheet. If he has a lot of sheets doing this one by one will quickly …
The Scenario Let’s say that you have a lot of sheets in your workbook and you want to merge all the data onto a single worksheet. If you have your data laid out in the same way on each sheet then this piece of VBA will do the trick for you. Maybe you have sales …
The Problem You have a sequence of numbers, and you want to find the numbers that are missing from that sequence. Let's use some VBA. Watch This Video - It Explains All This video explains how the code works, how to use it, and how to get the code and put it into your own …
This Excel Factor tip was sent in by Shannon Hommel of the UK. If you’re setting up a template or a workbook for other’s to use and you can’t password protect it (for whatever reason), then the next best thing is to highlight the cells containing formulas. This is not only an Excel ‘Best Practice’, …
As I promised last week, today’s tutorial is a dead easy macro that will allow you to extract a list of your worksheet tab names. You can then use this list to: Create an index of your worksheets. Why not add Hyperlinks so you can quickly navigate your workbook. Or use them to create references …
