Custom Excel Spreadshet VBA - Task & Project Management

Create a custom spreadsheet that will be used for task & project management.

Project tasks broken up into several categories with each category containing take and sub tasks.

Each task /subtask to have a check box next to it that strikes out the task and marks its status as complete once finished.

Each task / subtask will have priorities (Low, medium, high).

Each task will have a tag/category. Tags/categories will be generated from an editable table of tags categories.

Each task / subtasks will have option box for people assigned to task. People able to be assigned will be generated from an editable table of people.

Each task will have a start and end date. You click on the cell and you pick a date on a calendar.

Each task will have a description field where you can type descriptions and share links.

Will be able to easily add more tasks to list.

When adding tasks you can make it a subtasks to another task, and the subtasks will appear indented (like an outline format) under parent task.

On a separate tab you can generate reports that show tasls due today, by date, by person.

On a separate tab there will be a dashboard showing the % complete by category of task
It will also show % complete of entire project based on % complete of weighted tasks.

Tasks generate a gant chart or will be able to exportable to Microsoft project.

The spreadsheet can be copied and reused for other projects.

There may be other items that I need, but this is my intital idea.


About the recuiter
Member since Mar 14, 2020
Faqih Ethana
from Ontario, Canada

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions