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

Material

TCLICDSPA001

TCLICDSPA002

TCLICDSPA003 Table Two Plant ProfitC GLAc ETOI ICDTO 450013 ETHI ICDTH 470021 EAPT ANAPT 567001 EDAH CHOAH 491012 EPET ANAET 510001 <colgroup><col style="width:48pt" width="64" span="3"> </colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

Result Required

Material		Plant	ProfitC	GLAc
TCLICDSPA001		ETOI	ICDTO	450013
TCLICDSPA001		ETHI	ICDTH	470021
TCLICDSPA001		EAPT	ANAPT	567001
TCLICDSPA001		EDAH	CHOAH	491012
TCLICDSPA001		EPET	ANAET	510001
TCLICDSPA002		ETOI	ICDTO	450013
TCLICDSPA002		ETHI	ICDTH	470021
TCLICDSPA002		EAPT	ANAPT	567001
TCLICDSPA002		EDAH	CHOAH	491012
TCLICDSPA002		EPET	ANAET	510001
TCLICDSPA003		ETOI	ICDTO	450013
TCLICDSPA003		ETHI	ICDTH	470021
TCLICDSPA003		EAPT	ANAPT	567001
TCLICDSPA003		EDAH	CHOAH	491012
TCLICDSPA003		EPET	ANAET	510001

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>

Kindly help to generate a VBA

Regards
Josy