Create VBA Macro to create and update timeline from excel data into powerpoint
Budget: $75 – $150 AUD
I need a skilled VBA programmer to create a macro that generates a timeline view in a PowerPoint template from data in Excel. The macro should be able to:
- Create swimlanes for each stream and tasks
- Update shapes based on ShapeID and data from "taskdata"
-Once the shape postion manuallly changed the update menthod needs to update the shape position based on taskdata
The timeline view will be primarily used for project management overview. The swimlanes should be organized according to the streams in the "taskdata" tab.
Ideal skills for this project include:
- Proficient in VBA programming
- Experience with Excel and PowerPoint integration
- Understanding of project management concepts
- Ability to visualize data effectively
Please note that the version of Excel and PowerPoint that will be used for this project has not been specified.
- Create swimlanes for each stream and tasks
- Update shapes based on ShapeID and data from "taskdata"
-Once the shape postion manuallly changed the update menthod needs to update the shape position based on taskdata
The timeline view will be primarily used for project management overview. The swimlanes should be organized according to the streams in the "taskdata" tab.
Ideal skills for this project include:
- Proficient in VBA programming
- Experience with Excel and PowerPoint integration
- Understanding of project management concepts
- Ability to visualize data effectively
Please note that the version of Excel and PowerPoint that will be used for this project has not been specified.