Help Needed to Make Multiples using two tables

[josyayur]

Dear Freinds

I need help to generate a VBA Coding
I have two tables

Requesting your help on this

Table One
[TABLE="width: 104"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Material
[/TD]
[/TR]
[TR]
[TD]TCLICDSPA001
[/TD]
[/TR]
[TR]
[TD]TCLICDSPA002
[/TD]
[/TR]
[TR]
[TD]TCLICDSPA003

Table Two

[TABLE="width: 192"]
<colgroup><col style="width:48pt" width="64" span="3"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Plant[/TD]
[TD="class: xl65, width: 64"]ProfitC[/TD]
[TD="class: xl65, width: 64"]GLAc[/TD]
[/TR]
[TR]
[TD="class: xl65"]ETOI[/TD]
[TD="class: xl65"]ICDTO[/TD]
[TD="class: xl65, align: right"]450013[/TD]
[/TR]
[TR]
[TD="class: xl65"]ETHI[/TD]
[TD="class: xl65"]ICDTH[/TD]
[TD="class: xl65, align: right"]470021[/TD]
[/TR]
[TR]
[TD="class: xl65"]EAPT[/TD]
[TD="class: xl65"]ANAPT[/TD]
[TD="class: xl65, align: right"]567001[/TD]
[/TR]
[TR]
[TD="class: xl65"]EDAH[/TD]
[TD="class: xl65"]CHOAH[/TD]
[TD="class: xl65, align: right"]491012[/TD]
[/TR]
[TR]
[TD="class: xl65"]EPET
[/TD]
[TD="class: xl65"]ANAET[/TD]
[TD="class: xl65, align: right"]510001[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Result Required

[TABLE="width: 311"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Material[/TD]
[TD] [/TD]
[TD]Plant[/TD]
[TD]ProfitC[/TD]
[TD]GLAc[/TD]
[/TR]
[TR]
[TD]TCLICDSPA001[/TD]
[TD] [/TD]
[TD]ETOI[/TD]
[TD]ICDTO[/TD]
[TD]450013[/TD]
[/TR]
[TR]
[TD]TCLICDSPA001
[/TD]
[TD] [/TD]
[TD]ETHI[/TD]
[TD]ICDTH[/TD]
[TD]470021[/TD]
[/TR]
[TR]
[TD]TCLICDSPA001
[/TD]
[TD] [/TD]
[TD]EAPT[/TD]
[TD]ANAPT[/TD]
[TD]567001[/TD]
[/TR]
[TR]
[TD]TCLICDSPA001[/TD]
[TD] [/TD]
[TD]EDAH[/TD]
[TD]CHOAH[/TD]
[TD]491012[/TD]
[/TR]
[TR]
[TD]TCLICDSPA001[/TD]
[TD] [/TD]
[TD]EPET[/TD]
[TD]ANAET[/TD]
[TD]510001[/TD]
[/TR]
[TR]
[TD]TCLICDSPA002[/TD]
[TD] [/TD]
[TD]ETOI[/TD]
[TD]ICDTO[/TD]
[TD]450013[/TD]
[/TR]
[TR]
[TD]TCLICDSPA002[/TD]
[TD] [/TD]
[TD]ETHI[/TD]
[TD]ICDTH[/TD]
[TD]470021[/TD]
[/TR]
[TR]
[TD]TCLICDSPA002[/TD]
[TD] [/TD]
[TD]EAPT[/TD]
[TD]ANAPT[/TD]
[TD]567001[/TD]
[/TR]
[TR]
[TD]TCLICDSPA002
[/TD]
[TD] [/TD]
[TD]EDAH[/TD]
[TD]CHOAH[/TD]
[TD]491012[/TD]
[/TR]
[TR]
[TD]TCLICDSPA002
[/TD]
[TD] [/TD]
[TD]EPET[/TD]
[TD]ANAET[/TD]
[TD]510001[/TD]
[/TR]
[TR]
[TD]TCLICDSPA003[/TD]
[TD] [/TD]
[TD]ETOI[/TD]
[TD]ICDTO[/TD]
[TD]450013[/TD]
[/TR]
[TR]
[TD]TCLICDSPA003[/TD]
[TD] [/TD]
[TD]ETHI[/TD]
[TD]ICDTH[/TD]
[TD]470021[/TD]
[/TR]
[TR]
[TD]TCLICDSPA003[/TD]
[TD] [/TD]
[TD]EAPT[/TD]
[TD]ANAPT[/TD]
[TD]567001[/TD]
[/TR]
[TR]
[TD]TCLICDSPA003[/TD]
[TD] [/TD]
[TD]EDAH[/TD]
[TD]CHOAH[/TD]
[TD]491012[/TD]
[/TR]
[TR]
[TD]TCLICDSPA003[/TD]
[TD] [/TD]
[TD]EPET[/TD]
[TD]ANAET[/TD]
[TD]510001[/TD]
[/TR]
</tbody>[/TABLE]

Kindly help to generate a VBA

Regards
Josy