Below are a few screen-shots from an Excel© report that I recently developed for an energy company.  Using VBA, you can see that a spreadsheet can be used effectively as a database front end tool.  The first image shows how the blank report looks when you first open it.  Next, a macro called "Report" brings up the user input form.  Available items are selected from the list on the left and moved to the right with the pointing hand button.  Items can be removed back to the Available list if desired.  A date range is selected using the two DTPicker controls, and if you would prefer to select random dates, or add random dates to your date range, check one of those two options, and the user input form will expand downward to allow those options as well.  Click "Create Report" to output your requested information to the blank report spreadsheet.  The two last images show the output of the report, first without using the "Auto-Adjust Column Width" option, then last, the same report using the auto-adjust column width feature.