Copy row with merge column (gets an error)

[Jovillanueva]

Hi,

Newbie in macro. Can someone help me to figure out this error in my excel macro.
I'm trying to copy a certain range(cell) in my working file.

Or somebody can help me other idea on work on this in macro.
My source file is prod sched sheet, the desired tab is a result that i wanted to get.
I need this result to copy from other workbook.

I have a sample data that contains lines and model. Lines are compsed of 6 items but originally it has 14 lines.

Your help is very much appreciated. thank you.

Please Login or Register  to view this content.

attached is my sample data