Eastside Harley-Davidson in Bellevue, WA is the premier Harley-Davidson motorcycle dealership on the west coast. They are engaged in the sale of new and pre-owned motorcycles, parts, MotorClothes, rentals, and provide repair and maintenance service for their customer’s bikes. The company compiles a daily business report from which managers base many decisions. The report is compiled from several different sources on a daily basis and often consumes 30 minutes, if not more, of an employee’s time to assemble and compute the data. The sources of the daily transaction information include an Excel file which is received through e-mail, an Excel file which is manually pulled out of their in-house database, and several other figures which must be entered by hand. This VBA project minimizes, to the full extent possible, the number of steps, clicks, keystrokes, and time an employee must use to collect and analyze the information and then e-mail it to the managers group. This project also allows the user, at the beginning of each month, to reset the report with blank data as well as update the dates and goal information for each department. - James Tall
No comments:
Post a Comment