Search match value and insert data in rows

[christeen00]

Hi,
I've browsed related threads but I failed to find a relevant topic for my question.
I have two master data. Some records need to be duplicated.
Please refer to my attached file for details. My desired results is tabulated in sheet name "output".
Your help and guidance are appreciated.

[smuzoen]

You could do this with a macro. Add the code to a module and run the macro genOutput - see attached workbook

Please Login or Register  to view this content.

[nilem]

as an option

[christeen00]

Thanks smuzoen and nilem. both of your codes are working!
It's very helpful.
thank you very much