Aha. I'll see if I can understand what's going on and why the earlier
try resulted in circular calc at C:B1.

Is this calculating the ratio of input file sizes (rows)?

Thanks, Max.


Max wrote:
"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
---