Macro Mondays – Create A Macro To Copy Column Headers To All Other Worksheets In My Workbook
Want to do some coding? Me too of course you.. do it is #macromondays after after all. Today let's look at a creating a tiny Excel Macro to remove a lot of work. I always like to share my time...
Formula Friday – Find The Missing Values In My Columns Of Data
Hello it's #formulafriday. Time to have some #formulafun with a couple of functions to help me find values that are listed in one column of data and not the other. We are going to use the IF,...
Macro Mondays – How To Write A Macro To Close All Of Your Workbooks At Once
Hello Excellers time for some more #macromonday fun! This week again I wanted to share with you some code that saved me a tonne of time, a really small piece of code, but with big benefits. This...
Formula Friday – How About A Date…Converting Text To A Real Date With DATEVALUE
Hello Excellers time for some more #formulafridayfun. How about today we look at using the DATEVALUE function to convert text values in our Excel worksheets to a REAL Date value. First let's...
Formula Friday – Quickly Convert Formulas To Cells Values In Excel
Happy Friday Excellers, and welcome back to some more #formulafriday fun. Today let's take a look at how to easily display only cells values and not the Excel formulas that you have...
Formula Friday – How To Highlight All Cells That Contain A Formula Using ISFORMULA
Hello Excellers Happy Friday and it's time for some more #formulafriday fun. Today let's look at how to use the ISFORMULA function to achieve the following To test a cell reference to see if...