Run a Macro when a cell changes - Feature Image

How to Tell if a Cell Changed with VBA

Joseph Advanced, VBA 0 Comments

There are times when you want to run a macro when a cell changed. Maybe you want to do some special calculation when a cell changes. Or maybe you’d like to change the font to all uppercase. Or maybe you want to present your users with more meaningful data validation messages. Whatever the case may be, you can use Excel’s …

Anatomy of Structured references

Structured References [Infographic]

Joseph Advanced, Excel, Formulas 3 Comments

Are your formulas driving you crazy? Do they have a multitude of $ signs, colons, and letters referring to various columns? How many times have you looked at your complicated formulas and asked yourself “What data is this referring to?” I know I have. I mean, it’s not always easy remembering what $B2:$D10 is referring to. Luckily, we can leverage Structured …

Pixelator Example

Pixelate Images in Excel Cells

Joseph Advanced, Excel 0 Comments

Can you pixelate images in Excel? Or can you create an image in Excel by painting pixel-by-pixel? Well, a couple of years ago, I read an article about a Japanese man who was creating art using Excel. When I first heard about this, I immediately thought that he was painstakingly changing each cell's background color to create his art (i.e. creating the ...

Excel Dashboard Course

Joseph Advanced, Excel, Training 3 Comments

Do you want to really impress your manager? Or your manager’s manager? Then you should learn how to create Excel dashboards. Seriously, this is like catnip for managers. If you want to know how to create beautiful graphs that really convey the message of where the company is and where they need to go (which is extremely important to managers), then …

Alternative to Multiple IF Statements

Joseph Advanced, Excel, Formulas 3 Comments

Have you ever had to create a multiple IF statement? Ever notice how crazy it looks with all those parentheses and it's difficult to follow? Well, I was wondering if there was another way I could create a multiple IF statements that would be cleaner and easier to edit if need be. And I have. What I have discovered isn't ...

Hyperlinks are lost after sorting – VBA fix

Joseph Advanced, Excel, VBA 2 Comments

After I wrote my post about creating hyperlinks with external data, a subscriber told me about a problem they were having and was wondering if I could help.  The issue was that when they sorted hyperlinks after they were recently copied from one range to another, some hyperlinks would be removed from the range while others remained intact.  I hadn’t …

Excel – Create a Pivot Table Using SQL

Joseph Advanced, Dos and Don'ts, Excel, PivotTables 11 Comments

I use pivot tables extensively.  And there aren't many days that I don't create/use/manipulate pivot tables in some way.  However, I don't typically use worksheet data like in most examples you'll find online.  Instead, I usually create a custom SQL query to one of our SQL Server databases using SQL Server Management Studio (SSMS), test out the query, and then ...