/VBA-Portfolio

Collection of macros written in visual basic for applications

VBA-Portfolio

Description

This a collection of Microsoft Excel macros written visual basic for application. They range from simplifying small tasks to reorganizing data and creating reports.

The Porfolio

  • Eye in the Sky: An automatic roster generator based off forecasted resort guests occupancy and revenue spend. The aim of the macro spreadsheet is to generate a labour percentage at the benchmark of the budgeted 30%.