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...
Formula Friday – Calculating The Percentage Of A Target Yet To Be Achieved.
Hello Excellers time for more #formulafriday fun. Ever need to know how much you need to score on your last assessment to reach your target score so you know exactly how far away you really are...
Macro Mondays – Copy Excel Rows From One Worksheet To Another Worksheet Based On Criteria Using VBA
Hello Excellers, time for some more #MacroMonday fun. Today's Macro will allow you to quickly copy rows of data from one worksheet to another. This can be really useful if you carry out the same...