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...
Tag: Excel Tips
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...
Excel Formula Friday – Using Find And Replace To Quickly Change Formulas
Welcome Excellers to another #formulafriday blog post. Today let's take a look at how to quickly change your Excel formula without having to rewrite any of those formulas. I have...
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...
Hi Excellers, and welcome to another blog post in my #Exceltips #formulafriday 2021 Excel series. Today, let's look at how valuable a TRIM can be. The TRIM function is a really useful function to...