Macro to merge cells
 

Please a macro to merge cells of course codes based on
duration of course. For example the 3 cells of PM 01 in
the first row shoud be merged and only one PM 01 centered
in the cell covering 31 Jul to 2 Aug.

Table 1: Course Duration
Course Duration
HR 12 1
IM 01 3
MM 01 2
PM 01 3

Table 2 Courses Shedule
31-Jul-04 1-Aug-04 2-Aug-04 3-Aug-04 4-Aug-04
PM 01 PM 01 PM 01
PM 01 PM 01 PM 01
PM 02 PM 02 PM 02
PM 02 PM 02 PM 02
HR 12 HR 12 HR 12 HR 12 HR 12
HR 12 HR 12 HR 12 HR 12 HR 12
IM 01 IM 01 IM 01
IM 01 IM 01 IM 01
MM 01 MM 01 MM 01 MM 01
MM 01 MM 01 MM 01 MM 01
MM 01 MM 01 MM 01 MM 01
MM 01 MM 01 MM 01 MM 01
MM 02 MM 02 MM 02 MM 02