VBA code to Update Plan on a Page shapes based on shape data
$30-250 AUD
Teljesítve
Kiadva ekkor: körülbelül 1 évvel ezelőtt
$30-250 AUD
Teljesítéskor fizetve
VBA code is required to Read TaskData tab's Table "ShapeData" and Update shape's location based on start/finish dates on the Poap
Poap will contain 2 types of Shapes
Milestones-shapename starting with "Milestone_"
Tasks-shapename starting with "Task_"
Method e.g.
Loop through all the shapes(Milestone/Task type shapes only) in the Poap
If Shape found, go to TaskData tab "Shapedata" table and check if the ShapeID is Found
If Found , capture the start and finish date and update the Shape location based on the Poap timeline
Note: Poap header month cell size could be reduced or expanded by the user, and the size need to calculated through code to figure out the shape location
Please refer attached sample file
Hello,
I am an Excel and VBA/Macro expert. I have checked the Poap and TaskData tabs and understood the instructions/requirements. I offer my services to create the required VBA code.
You can check my reviews for quality of work and client satisfaction.
Looking forward to working with you.
Thanks,
Hamid