Expand Excel: Inventory Management Database with Custom Reporting
60 Hour Project
A small plant grower company had a robust inventory management system built in Excel ten years ago that they had outgrown. The size of their data had grown to such that the macro was regularly crashing Excel, and they had additional reporting requirements. We moved the logic into Access and added the reporting module. The process which was already semi-automated in Excel but took 20 minutes to run on a daily basis was completely automated and scheduled to run nightly, with the reports ready when they arrived to work each morning.