Copy paste depending on certain criteria (VBA)

This Post is a further requirement to one of my old thread (solved)

http://www.excelforum.com/excel-prog...html?p=2952079

I would like the output now to be different as attached. The old code and file is attached. Sample.xlsm

Give this a try

Please Login or Register  to view this content.

It works perfect...