Mix And Match – Get all possible permutations of an unlimited number of lists in Excel


This post is a little fun, not much of a Struggle I guess. In excel, we use permutations more often than we realize. Say you have twenty performance metrics and you’d like to monitor them for each month, imagine how much copy pasting and concatenating would need being done to get your column header namesContinue reading “Mix And Match – Get all possible permutations of an unlimited number of lists in Excel”

Excel Report Generator – Fill Reports with Records, Print and Save Automatically


Many small-scale businesses do not use database management systems to generate reports. Most of them stick to spreadsheet packages. Unfortunately Spreadsheet softwares are not equipped with ¬†advanced query and report generating features. However, some Excel users struggle with Reports that they update, save and print manually. It is a very tedious job, but VBA canContinue reading “Excel Report Generator – Fill Reports with Records, Print and Save Automatically”

Local trumps Global – Local Named Ranges make the spreadsheet more tractable


Creating user friendly spreadsheets is not just a professional courtesy anymore. We have the obligation to help users decipher the spreadsheet we so hastily put together. Spending a little extra time setting up well designed spreadsheets help a firm reduce future costs by reducing the time spent on testing and scrutinizing the sheet. improving theContinue reading “Local trumps Global – Local Named Ranges make the spreadsheet more tractable”