You are tasked with building VBA code to solve some sort of Excel problem that plagues you. This can be an academic problem or a work-related problem. It
should be related to
accounting, finance, or business in general.
At a minimum, your code must incorporate:
• variables,
• looping,
• and logic
I will give bonus points for more complexity.
You must also add comments in your code explaining what the code is doing.
The project, and a brief (2-page max) writeup.
The writeup should explain your reason for developing this code, for example:
• What will this help with / how much time does it save?
• How would you have to do this work if you didn’t have a VBA macro or function?
• Why is your VBA macro or function better than an existing Excel function or tool?
The writeup should also briefly explain what the code is doing/how it works