VBA

I use VBA for my work at UPS during our end of the night holdover. I created a handful of macros in the that time to expedite the task of processing holdover and outbound truck movements.

Holdover
This macro modifies a generated excel sheet from the Airhub database. The report contains all of the shipments that did not move on aircraft due usually to capacity. The macro deletes most of the extraneous data in the report including the header and extra columns. Then loops through the report deleting any container that has been accounted for at the freight facility. What is left are containers that have yet to arrive back at the building giving a accurate number of containers missing for holdover.

Trucks
This macro consists of 2 modules in a preexisting excel workbook. Module 1 was written to pull outbound truck movement data from an access database and populate an excel report with the containers for the movement. The report was based on where the containers needed to be moved to be processed. Module 2 pulls data from a backup workbook that is used when the access database fails to function correctly. It servers the same purpose as module one but processes the backup workbook differently. The macro opens the backup workbook and iterates through all the data in the book until it reaches the end. The report is separated in the same way as Module 1.