Excel VBA Tool for a Large Corporation

Complex Excel VBA project. Months of full time work. More than 10 thousands of VBA code rows.

  • Complex Excel ribbon tabs and VBA forms created, progress bars used
  • Multiple VBA procedures created: to open template files, to migrate data from older versions, to import and clean data from excel files, to perform complex calculations, to refresh pivot tables, to build matrix data view, to replicate data records and sheets, to hide and unhide data, to log all errors into the remote MySQL database, to automatically test the tool
  • Complex excel formulas, named ranges, named tables, pivot tables, charts created