I need to create an excel workbook that tracks the hourly workload of members of my team (up to 20 members). The requirements are:
- A summary sheet that captures and synthesizes the hourly workload of each member, distinguishing between sold projects and proposed (yet to be sold) projects per week;
- A button for creating a new project sheet based on a pre-defined template (up to 100 projects simultaneously);
- The individual sheets feeding the summary sheet with the hourly workloads of every team member;
- A button on every project sheet that converts it from a "proposed" to a "sold" project (and the consequent reflection of that on the summary sheet)
The project is quite simple and can be completed with basic VBasic programming.
Thank you for bidding on the project.