My Project Sceduler

General:
1. Macro will create schedule on sheet with index = 1
2. Please do not change name of sheet "Setting"
3. Other sheet will recognize as input ex Sheet Project A , Project B
4. Macro will copy sheet of input from column B tp I

How to setting:
1. In sheet Setting input startDate, FinishDate
2. Input Datestep, <0 is not allowed
3. Choose shape, you can choose Line /rectangle
4. Percentage task progress only can be seen in rectangle shape format
5. Input headerdata for schedule display
6. Input Title

How to create input:
1. Fill any, from column B to I
2. Date start and Date finish are Date format input
3. Progress is percentage format input
4. In sort option, you can choose 0(no sort), 1(ascending), 2/others(descending)

How To Create:
1. Right click On Sheet Schedule, Scheduler > Update
2. if you want to hide finished task, choose Hide 100% Task

Screen Shoot:
Line style

 Rectangle style

Download File