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

Excel Report Generator

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.

Continue reading “Excel Report Generator – Fill Reports with Records, Print and Save Automatically”

Advertisements

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

Create from Selection

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

  1. reducing the time spent on testing and scrutinizing the sheet.
  2. improving the productivity of the worker.
  3. helping the ‘new guy’ figure out the sheet in no time.
  4. increasing the visibility of errors, consequently reducing the need for rework.

Continue reading “Local trumps Global – Local Named Ranges make the spreadsheet more tractable”