Tailoring shop needs to upgrade to more dynamic excel model

Our current VBA based excel model has the following mechanisms already: 1. Inputting and management of customer measurements and contacts 2. Order tracking and management 3. Analytics (which materials are most popular) We are looking to improve upon our current model by adding new functionalities and increasing efficiency of our current ones. The new model should include: a. customer activity (tracking repeat customers) b. which fabrics are most popular c. business activity - (which months have highest activity) d. tracking lead time for suppliers -(time between manufacturing and when customer receives shirt) e. % of shirts with lining f. % of shirts with alterations â (tracking quality of manufacturerâs products) g. order tracking and management â (invoice generation) We require following functionalities and tools to be in the model: 1. VBA based model 2. Dynamic charting 3. Flexible filtering mechanisms to enable quality analysis I will send you my current excel model for you to work on. Hopefully you will not need to develop from scratch.