Formula Friday – Copy Formula Down When Formula Is Not Directly Next To Your Data Set
Hello Excellers, and welcome another #FormulaFriday in my #Excel 2020 series. I just love this Excel formula trick, It is a really quick way to copy a formula down a column when the formula is not...
Macro Mondays – How To Run An Excel Macro Automatically When You Open Your Excel Workbook
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. So, today I will show you a number of different ways to automatically run a VBA macro when you open...
Formula Friday – Flag Multiple Matches In Your VLOOKUP Formula
Hello Excellers, yes it is #FormulaFriday again. Time for some more #Excel formula fun. The VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in larger data...
Have you had or are having issues with Excel? If indeed you are having issues it may be due to some files or Add Ins that are loaded as Excel starts. In order to troubleshoot or test this theory...
Macro Mondays – A Simple Macro To Refresh All Data Connections When Opening An Excel Workbook
Happy Monday!, and it is Macro Time. Welcome to another #MacroMonday #Excel blog posts in my 2020 series. Today we will write a simple macro to refresh all data connections when your Excel...
Hi Excellers, welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel formula series. I really do love the watch window feature in Excel. Being able to monitor numerous cell...