Well, other than the first data row, I can see no apparent relationship between the rows you want the data to be replicated in and their sources. Unless you can explain the logic, no-one is likely to be able to provide a solution.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]