These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 10, 2015

Spreadsheet Data Extraction Program

This macro program was built for Xavier Farms in Moscow, Idaho. Xavier Farms is a producer of potatoes and potato products and operates many different fields that require power for water pumps. Analysts at Xavier Farms conduct an annual power usage review that requires compiling information from many tabs in 15 to 20 different Excel worksheets. This process can take anywhere from 3 to 4 hours and can easily result in mistakes. The sub-procedure/macro in this module enables the user to simply tell Excel where the data files are located, where the previous year’s comparisons are, and then click a button located on the ribbon to begin the compiling process. Excel then creates a new comparison file for the year being analyzed, copies the previous year’s data, and extracts necessary data into the new spreadsheet for further analysis. Finally, the data are formatted as a table to finish the process.

No comments:

Post a Comment

Blog Archive