Dear All,
I have project wise activity data in one sheet and based on entry of data I want to change the other sheet's shape, if we add new record or change the record then it should create the shape or change the shape accordingly;
This is only a sample; in reality, I have a long list of activities, each with its own set of sub-activities.
- In the attached Sheet "Data", I'll add / update / delete the row then base on it sheet "Progress Shape" should update as shown in the attached file, the shape should begin on that date in the same row cell and continue until the End Date with the same color shape as the activity color in the "Data" sheet.
- If some activity has some sub-activity then shape should be in same row as enter start and end date.
Please help me to get desired output.
Thanks & Regards,
Shahid
Bookmarks