Hello, Excellers welcome back to my blog for another #macromondays #exceltips blog post in my 2019 Monday Series. Today lets look at creating a list of unique values. We will make this lightning...
Category: Blog
A Macro To Copy Cells Based on Certain Criteria in your Excel Worksheet.
Hello Excellers and welcome to another Excel Tip in my #macromonday 2019 series. Today let's look at how to copy cells based on specific criteria in your Excel worksheet. This is a macro I created...
Welcome back to another blog post in my 2019 series of #macromonday where I share some awesome Excel tips. Today let's look at how to write an Excel VBA Macro to quickly protect any cell in your...
Macro Monday – How To Trim Spaces From All Cells In A Selected Range On Your Excel Worksheet
Welcome To Macro Mondays again Excellers. I want to share another Excel Tip in my 2019 blog post series. Today let's look at a really useful macro which will TRIM spaces from a user...
Happy Friday Excellers. Time for some more Formula Fun. Today I want to show you how to use SUMIF in Excel to sum only the POSITIVE numbers in your data set. Let's take an...
Back To Basics. Understanding Excel Formula Errors – Formula Friday
Are you ready to get back to basics today with some refreshment of the meaning of the Excel Formula errors that you get sometimes in your worksheets?. It's time to review, and if you are new...