MS Project VBA for Report Automation -- 2
Budget: $30 – $250 AUD
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports.
So the person MUST have Ms Project experience to understand how project constructs data.
Key tasks include:
1. Utilizing VBA to automate the generation of project summary reports.
2. These reports must provide a list of all tasks and their current status
3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors.
The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is ESSENTIAL. I'm looking for someone who understands project progress reporting and can deliver efficient, accurate results.
If it turns out that it is not possible to achieve the type of reporting in MS Project then i will consider outputting the data to Excel, and creating suitable dashboards in Excel. (I might also later on ask to repcate these dashboards in Powerbi, but at the current project we do not have Powerbi available)
So the person MUST have Ms Project experience to understand how project constructs data.
Key tasks include:
1. Utilizing VBA to automate the generation of project summary reports.
2. These reports must provide a list of all tasks and their current status
3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors.
The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is ESSENTIAL. I'm looking for someone who understands project progress reporting and can deliver efficient, accurate results.
If it turns out that it is not possible to achieve the type of reporting in MS Project then i will consider outputting the data to Excel, and creating suitable dashboards in Excel. (I might also later on ask to repcate these dashboards in Powerbi, but at the current project we do not have Powerbi available)