Hello, Excellers and welcome back. It is Friday Formula time again. Today's post will look at how to use wildcards in a VLOOKUP formula. Let's begin with an example to demonstrate the...
Posts by Barbara
Welcome back Excellers to another blog post in my #macromonday 2019 series. Today we will create an easy Excel VBA macro to highlight negative numbers easily with conditional formatting. This will...
Add 5% to my Sales Targets Without Using Extra Columns Or Cells
Hello, Excellers. welcome to another blog post with an #exceltip in my 2019 #formulafriday series. Today I want to share with you how to carry out a calculation with no excel formula, and no...
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...
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...