Project Tracking Excel Workbook

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.

Project ID: 40217269

Location: United States