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...
Macro Mondays – How To Prevent A Workbook Closing Until A Cell Is Populated By The User
Hello Excellers and welcome to another Macro Monday blog post. Today let's look at forcing a user to populate a specific cell in the workbook before they are allowed to close it. If you want...
Formula Friday – Easily SUM Values From Different Excel Sheets With The Same Cell Address
Time for some more Friday Formula Fun. Today we are looking at the good old SUM function, but we are going to use it to SUM the values from the same cell in multiple Excel worksheets. What does...
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...
Macro Mondays -Open An Excel Workbook To A Specific Worksheet Tab
Hello Excellers, welcome to another blog post in my #MacroMonday series. Most Excel workbooks contain more than one worksheet, which can be helpful when you want to keep related data together....