In my continuing quest to build a better Gantt-like chart (thanks for
the help from David G others!) I need to further refine my input data
as follows (below).

I am looking for help with some starter VBA code I can modify.Not
familiar with VBA loops and such so I am bit hesitant.

Input (sheet1) (May have 100's of records)
Task Name Start Finish Duration Effort(HRS)
(Biz days!)
Install Hardware 6/8/2007 6/13/2007 4 32


Output (sheet2)

Task Name Start Finish Duration Effort(HRS)
(Biz days!)
Install Hardware 6/8/2007 6/8/2007 1 8
Install Hardware 6/11/2007 6/11/2007 1 8
Install Hardware 6/12/2007 6/12/2007 1 8
Install Hardware 6/13/2007 6/13/2007 1 8