Project Tracking Excel Workbook
Budget: $15 – $30 USD
I need a single Excel workbook that lets me see every project at a glance while still giving each project manager a personalised view. The opening tab will act as a master register containing all projects. From that master list, data should flow automatically into individual tabs—one tab per PM—so they only see the projects assigned to them.
For every project I have to capture:
• assigned project manager
• employees on the job
• core project details (name, client, start & end dates, status, and any notes)
The current spreadsheet and additional details will be provided upon hire.
Drop-downs, conditional formatting, simple formulas or Power Query should keep everything synchronised; use VBA only if it truly simplifies the workflow. The file should arrive fully formatted, with a bit of sample data that proves all links work, and clear notes so I can adjust fields later.
When you apply, a short note about similar tracking work you’ve tackled is enough—I’m selecting based on experience, not lengthy proposals.
For every project I have to capture:
• assigned project manager
• employees on the job
• core project details (name, client, start & end dates, status, and any notes)
The current spreadsheet and additional details will be provided upon hire.
Drop-downs, conditional formatting, simple formulas or Power Query should keep everything synchronised; use VBA only if it truly simplifies the workflow. The file should arrive fully formatted, with a bit of sample data that proves all links work, and clear notes so I can adjust fields later.
When you apply, a short note about similar tracking work you’ve tackled is enough—I’m selecting based on experience, not lengthy proposals.