I am recently retired and new to Freelancer but I spent over 40 years in software development. During my career I built many Excel/VBA macros to handle spreadsheets similar to the one described in your requirements. I am available to start work on this project immediately. Some of my accomplishments during my career include:
Building VB prototypes and small scale applications, along with VBA scripts to automate Excel spreadsheets.
• Developing, enhancing, and maintaining MS Office applications, and handling both frontend and backend development procedures.
• Designing, configuring, developing, and implementing enhancements and production fixes to existing systems.
• Developing and implementing new systems, and ensuring that their configuration is properly handled.
• Using development best practices, and appropriate patterns to develop required software solutions.
• Creating and maintaining technical documentation, including user manuals and guides.
• Formulating and defining system scope and objectives, based on the individual needs of each user.
• Analyzing and revising existing system logic difficulties, and ensure that technical knowledge of all phases of application systems is maintained.
• Developing, maintaining and supporting existing MS Excel VBA applications, and analyzing and converting business requirements as needed.