"AirBoss" wrote in message
oups.com...
Max,
Looks good. Pardon my ignorance, but is this a macro?

It's a formulas play, not a macro

Also seems circular at C:B1.

Not sure what's happening over there ..
but here's a working sample for illustration / easy reference:
http://www.savefile.com/files/344917
Merge data rows from 2 sheets at fixed ratio.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---