extrect period of a class from time table

[sunilkumarduhan]

[TABLE="class: grid, width: 500, align: right"]
<tbody>[TR]
[TD][TABLE="width: 1030"]
<colgroup><col span="2" style="text-align: right;"><col style="text-align: right;"><col style="text-align: right;"><col span="6" style="text-align: right;"></colgroup><tbody>[TR="class: grid"]
[TD="align: right"]NAME[/TD]
[TD="align: right"]DAY[/TD]
[TD="align: right"]DAY PERIOD 1 NAME[/TD]
[TD="align: right"]DAY PERIOD 2 NAME[/TD]
[TD="align: right"]DAY PERIOD 3 NAME[/TD]
[TD="align: right"]DAY PERIOD 4 NAME[/TD]
[TD="align: right"]DAY PERIOD 5 NAME[/TD]
[TD="align: right"]DAY PERIOD 6 NAME[/TD]
[TD="align: right"]DAY PERIOD 7 NAME[/TD]
[TD="align: right"]DAY PERIOD 8 NAME[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUNIL[/TD]
[TD="align: right"]MONDAY[/TD]
[TD="align: right"]MONDAY ALL ARRANG SUNIL[/TD]
[TD="align: right"]MONDAY SUNIL[/TD]
[TD="align: right"]MONDAY X-B NSC SUNIL[/TD]
[TD="align: right"]MONDAY SUNIL[/TD]
[TD="align: right"]MONDAY 8-B NSC SUNIL[/TD]
[TD="align: right"]MONDAY SUNIL[/TD]
[TD="align: right"]MONDAY IX-H NSC SUNIL[/TD]
[TD="align: right"]MONDAY SUNIL[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUNIL[/TD]
[TD="align: right"]TUESDAY[/TD]
[TD="align: right"]TUESDAY ALL ARRANG SUNIL[/TD]
[TD="align: right"]TUESDAY SUNIL[/TD]
[TD="align: right"]TUESDAY X-B NSC SUNIL[/TD]
[TD="align: right"]TUESDAY SUNIL[/TD]
[TD="align: right"]TUESDAY 8-B NSC SUNIL[/TD]
[TD="align: right"]TUESDAY SUNIL[/TD]
[TD="align: right"]TUESDAY IX-H NSC SUNIL[/TD]
[TD="align: right"]TUESDAY SUNIL[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUNIL[/TD]
[TD="align: right"]WEDNESDAY[/TD]
[TD="align: right"]WEDNESDAY ALL ARRANG SUNIL[/TD]
[TD="align: right"]WEDNESDAY SUNIL[/TD]
[TD="align: right"]WEDNESDAY X-B NSC SUNIL[/TD]
[TD="align: right"]WEDNESDAY SUNIL[/TD]
[TD="align: right"]WEDNESDAY 8-B NSC SUNIL[/TD]
[TD="align: right"]WEDNESDAY IX-H NSC SUNIL[/TD]
[TD="align: right"]WEDNESDAY IX-H NSC SUNIL[/TD]
[TD="align: right"]WEDNESDAY SUNIL[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUNIL[/TD]
[TD="align: right"]THURSDAY[/TD]
[TD="align: right"]THURSDAY ALL ARRANG SUNIL[/TD]
[TD="align: right"]THURSDAY SUNIL[/TD]
[TD="align: right"]THURSDAY X-B NSC SUNIL[/TD]
[TD="align: right"]THURSDAY SUNIL[/TD]
[TD="align: right"]THURSDAY 8-B NSC SUNIL[/TD]
[TD="align: right"]THURSDAY IX-H NSC SUNIL[/TD]
[TD="align: right"]THURSDAY IX-H NSC SUNIL[/TD]
[TD="align: right"]THURSDAY SUNIL[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUNIL[/TD]
[TD="align: right"]FRIDAY[/TD]
[TD="align: right"]FRIDAY ALL ARRANG SUNIL[/TD]
[TD="align: right"]FRIDAY X-B NSC SUNIL[/TD]
[TD="align: right"]FRIDAY X-B NSC SUNIL[/TD]
[TD="align: right"]FRIDAY SUNIL[/TD]
[TD="align: right"]FRIDAY 8-B NSC SUNIL[/TD]
[TD="align: right"]FRIDAY SUNIL[/TD]
[TD="align: right"]FRIDAY IX-H NSC SUNIL[/TD]
[TD="align: right"]FRIDAY SUNIL[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUNIL[/TD]
[TD="align: right"]SATURDAY[/TD]
[TD="align: right"]SATURDAY ALL ARRANG SUNIL[/TD]
[TD="align: right"]SATURDAY X-B NSC SUNIL[/TD]
[TD="align: right"]SATURDAY X-B NSC SUNIL[/TD]
[TD="align: right"]SATURDAY SUNIL[/TD]
[TD="align: right"]SATURDAY 8-B NSC SUNIL[/TD]
[TD="align: right"]SATURDAY SUNIL[/TD]
[TD="align: right"]SATURDAY IX-H NSC SUNIL[/TD]
[TD="align: right"]SATURDAY SUNIL[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]0[/TD]
[TD="align: right"]SUNDAY[/TD]
[TD="align: right"]SUNDAY [/TD]
[TD="align: right"]SUNDAY [/TD]
[TD="align: right"]SUNDAY [/TD]
[TD="align: right"]SUNDAY [/TD]
[TD="align: right"]SUNDAY [/TD]
[TD="align: right"]SUNDAY [/TD]
[TD="align: right"]SUNDAY [/TD]
[TD="align: right"]SUNDAY [/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUDHIR[/TD]
[TD="align: right"]MONDAY[/TD]
[TD="align: right"]MONDAY ALL ADMN SUDHIR[/TD]
[TD="align: right"]MONDAY SUDHIR[/TD]
[TD="align: right"]MONDAY SUDHIR[/TD]
[TD="align: right"]MONDAY VII-B MATH SUDHIR[/TD]
[TD="align: right"]MONDAY VIII-A MATH SUDHIR[/TD]
[TD="align: right"]MONDAY SUDHIR[/TD]
[TD="align: right"]MONDAY IX-H SKT SUDHIR[/TD]
[TD="align: right"]MONDAY SUDHIR[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUDHIR[/TD]
[TD="align: right"]TUESDAY[/TD]
[TD="align: right"]TUESDAY ALL ADMN SUDHIR[/TD]
[TD="align: right"]TUESDAY SUDHIR[/TD]
[TD="align: right"]TUESDAY SUDHIR[/TD]
[TD="align: right"]TUESDAY VII-B MATH SUDHIR[/TD]
[TD="align: right"]TUESDAY VIII-A MATH SUDHIR[/TD]
[TD="align: right"]TUESDAY SUDHIR[/TD]
[TD="align: right"]TUESDAY IX-H SKT SUDHIR[/TD]
[TD="align: right"]TUESDAY SUDHIR[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUDHIR[/TD]
[TD="align: right"]WEDNESDAY[/TD]
[TD="align: right"]WEDNESDAY ALL ADMN SUDHIR[/TD]
[TD="align: right"]WEDNESDAY SUDHIR[/TD]
[TD="align: right"]WEDNESDAY SUDHIR[/TD]
[TD="align: right"]WEDNESDAY VII-B MATH SUDHIR[/TD]
[TD="align: right"]WEDNESDAY VIII-A MATH SUDHIR[/TD]
[TD="align: right"]WEDNESDAY IX-H MATH SUDHIR[/TD]
[TD="align: right"]WEDNESDAY IX-H SKT SUDHIR[/TD]
[TD="align: right"]WEDNESDAY SUDHIR[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUDHIR[/TD]
[TD="align: right"]THURSDAY[/TD]
[TD="align: right"]THURSDAY ALL ADMN SUDHIR[/TD]
[TD="align: right"]THURSDAY SUDHIR[/TD]
[TD="align: right"]THURSDAY SUDHIR[/TD]
[TD="align: right"]THURSDAY VII-B MATH SUDHIR[/TD]
[TD="align: right"]THURSDAY VIII-A MATH SUDHIR[/TD]
[TD="align: right"]THURSDAY IXH MATH SUDHIR[/TD]
[TD="align: right"]THURSDAY X-A MATH SUDHIR[/TD]
[TD="align: right"]THURSDAY SUDHIR[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUDHIR[/TD]
[TD="align: right"]FRIDAY[/TD]
[TD="align: right"]FRIDAY ALL ADMN SUDHIR[/TD]
[TD="align: right"]FRIDAY SUDHIR[/TD]
[TD="align: right"]FRIDAY SUDHIR[/TD]
[TD="align: right"]FRIDAY VII-B MATH SUDHIR[/TD]
[TD="align: right"]FRIDAY VIII-A MATH SUDHIR[/TD]
[TD="align: right"]FRIDAY SUDHIR[/TD]
[TD="align: right"]FRIDAY IX-B MATH SUDHIR[/TD]
[TD="align: right"]FRIDAY SUDHIR[/TD]
[/TR]
[TR="class: grid"]
[TD="align: right"]SUDHIR[/TD]
[TD="align: right"]SATURDAY[/TD]
[TD="align: right"]SATURDAY ALL ADMN SUDHIR[/TD]
[TD="align: right"]SATURDAY SUDHIR[/TD]
[TD="align: right"]SATURDAY SUDHIR[/TD]
[TD="align: right"]SATURDAY VII-B MATH SUDHIR[/TD]
[TD="align: right"]SATURDAY VIII-A MATH SUDHIR[/TD]
[TD="align: right"]SATURDAY SUDHIR[/TD]
[TD="align: right"]SATURDAY IX-H HINDI SUDHIR[/TD]
[TD="align: right"]SATURDAY SUDHIR[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

---

i'm new to this pateform and have little bit knowledge of macro. please help me, i am making time table of 45 classes with 8 subjects and 90 teachers.

i want to automatically copy only cells (i want selection of data with use of user form ) which contain "X-B" text and paste them in second sheet (which have user form) in the same column.