Hello Excellers, welcome back to another #MacroMonday #Exceltips blog post in my Excel series. Today I will demonstrate how to write a very small Excel VBA macro that will quickly remove any text...
Posts by Barbara
Hello, Excellers. Welcome back to one of the last #FormulaFriday Excel blog posts of 2020. Often you will need to display a value as well as percent in the same report. So, more formula (or no...
Hello Excellers, welcome back to another #MacroMonday blog post in my #Excel 2021 series. Today I will share a quick and simple Excel Macro. It allows a user to insert as many new worksheets into...
This is a quick and easy way to change MULTIPLE PIVOT TABLE FILTERS on your Excel reports. For example, you may have multiple worksheets of Sales People, and they all have their own...
Hello Excellers and welcome to another #Excel #MacroMonday blog post in my 2021 series. I want to show you how to export and save all of your Excel worksheets in an Excel workbook as separate PDF...
Formula Friday – Applying Names To Your Existing Excel Formulas.
Hi Excellers, #formulafriday time again. Welcome back to another blog post in my 2021 series. Today is a bit different, I want to share with you how to rename or apply names to formulas that you...