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...
Formula Friday – 2 Ways To Create A Dynamic Named Range In Excel
Time for some more #formulafriday fun. Today let's look at 2 ways to create a name range in Excel. If you want to read more about using named ranges in your Excel formulas then you can read my...
Formula Friday – Use A VLOOKUP Formula Across Multiple Excel Worksheets
Hi Excellers today let's flex our formula muscles and tackle a VLOOKUP question, how to carry out a VLOOKUP over multiple worksheets in the same workbook. Suppose I have three worksheets with data...
Formula Friday – Top 3 Reasons Not To Use Hard Coding In Excel Formulas
Hi Excellers, it is time for some more formula fun on #formulafriday. Today I want to share with you my Top 3 Reasons Not To Use Hard Coding In Excel Formulas If you want see see all of the blog...
Macro Mondays – A Macro To Create An Alert When A Cell Value Exceeds Its Target Value
Hello Excellers, time for some #macromondays fun again. Today I want to share with you a really small piece of code, that will alert the user when a cell value reaches or exceeds a it's target...