This article is meant for those individuals/businesses who sometimes experience a need to use their spreadsheets in the (somewhat "impersonal"?) manner described above, to get the results they want. That need would often arise out of their lack of requisite skills to get the spreadsheet to behave the way they want _ or limited time to devote towards incorporating necessary automation to make it do so.
In addition, visualise it having dynamic query/report drop menu interfaces, and a variety of custom buttons: for navigation(within and between worksheets), printing, data export (as PDF documents or spreadsheet files), saving, auto_data filtering, auto_charts plotting, auto_backup of files, user login authentication (for documents with sensitive or confidential content) etc.
At times, they would prefer to click a button that says "Print ABC", or "Print XYZ" report, instead of having to crawl all over the huge spreadsheet(and get "lost" every now and then), to highlight and print different report pages. Using a custom built data entry form to make data entries into 14 different cells in different parts of a table(at the same time/with one click) would, for them, be "heaven" compared to making the entries one at a time.
To experience the type of automation I refer to, you can email FREE demos of sample automated Excel VB driven spreadsheet applications like Ƒ) a Training Tracking Database(TM), ƒ) a Fiveƕ) Year Income & Expense Monitor(TM) or Ɠ) an Export Packing List & Invoice Generator(TM) to yourself using the file mailer on my website.
excel spreadsheet examples
spreadsheet templates for small business
excel budget templates