Custom Excel Spreadshet VBA - Task & Project Management




Samuel Canada


OpenAug 9, 2018
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 it's 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.

Skills & Expertise Required

Data Analytics Data Science Excel VBA Microsoft Excel Microsoft Excel PowerPivot Spreadsheets Statistics VBA 

Offer to work on this project closes in 15 days!

Submit A Proposal

Share this project with your friends

Freelancers You May Hire

Here are our top professional picks for you to hire

Similar Projects

Data Visualization - Tableau Pro ne...


We're looking for a Tableau expert to redesign a series of marketing reports. We would provide you with the existing workbooks and data source extract to work with.
read more

Hourly, $28.00

Sales Analysis of an Ecommerce busi...

Sales analysis data from QB data
1) Churn rate
2) Customer acquisition cost
3) Sales / % increase MOM (Month on Month) + Graph
4) Average basket size
5) Transactions / % more

Hourly, $36.00

MS office and communication configu...

Someone who can work patiently with a skilled individual consultant working from home

Hourly, $16.00

Statistician or someone who knows h...

Statistician who can to Tukey's range test about science thesis or extraction.
Someone who can finish it in less than 1 day


Fixed, $19.00