Macro Monday – How To Delete An Excel Worksheet If A Range Of Cells Is Empty
Hello Excellers, today let's look at how to delete all worksheets in an Excel workbook where a certain range of cells is empty. I use this piece of code every week on a report generated...
Hi Excellers, time for some more #formulafriday fun. This blog post is based on a question I was asked by a subscriber a few weeks ago and I thought it would be a good share it on...
Formula Friday – Easily Add Symbols To Your Excel To Do List Using The IF Function
Happy Friday Excellers. If you use a To Do List in Excel like I do then here is a great way to highlight with some great but easy visualization, the status of your To List Activities. We can use...
Macro Mondays – Mail Your Active Workbook As An Attachment With An Excel Macro
Hello Excellers, I am going to share what I think is one of my favorite Macros to date. It emails the active workbook as an attachment from Outlook. How often do you send the same updated...
Formula Friday – Highlight Overdue Tasks With Conditional Formatting And A Logical Formula
Have you started the New Year with some new good habits, maybe you are tracking your To Do or Task List in Excel (why wouldn't you?). Here is a great way to highlight overdue tasks, using...
Formula Friday – Write Formulas Faster With Auto Correct In Excel
Hello Excellers, time for some more formula fun, or some fast formula writing fun. Let's look at using one of Excel's features - Auto Correct and put it to another use to speed up Formula...