I am seeking the following improvements to the macro; any help appreciated.

1) Allow the ability to set starting cell  from the macro paints the gantt
chart (b4, c3 etc)
2) The macro clears teh whole sheet2 (I think) before proceeding to paint; Add
the ability to clear from starting cell from item 1 above
3) Allow the ability to group/sort after the gantt is painted. That needs
additonal columns to the left ProjectID. The macro will fill rows  in these
columns by copying a specific cell from datasheet(sheet1) e.g Territory,
SalesDept.

ProjectID TaskID start  Week Duration

Territory SalesDeptID ProjectID Tasks
North Direct Project1 Design 26 1
Direct Project1 Install Hardware 37 4
Direct Project1 Install Software 41 4
Direct Project1 Configure 49 1
Direct Project1 Prep 50 2
Direct Project1 Support 52 1
South Tele Project2 Design 2 1
Tele Project2 Install Hardware 15 2
Tele Project2 Install Software 17 3
Tele Project2 Configure 20 1
Tele Project2 Prep 21 1
Tele Project2 Support 22 4