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 names in place?
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 can make it better. I have created a spreadsheet application you may used to fill a template/report with different “Records“, save each in a separate workbook, and print automatically.
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 the productivity of the worker.
- helping the ‘new guy’ figure out the sheet in no time.
- increasing the visibility of errors, consequently reducing the need for rework.
If you’d like to loop through all the cells in a sheet, it is very tempting to use something like the following:
Sub LoopThroughCells() Dim rngCell As Range For Each rngCell In Excel.ActiveSheet.Cells 'Type your code here Next rngCell End Sub