The basic issue, though, is the same - how to populate the output range with the data.

A VBA solution might consist of nothing more than output the formulae I posted to the relevant cells. Hardly a great advance on what you already have and the end result would be exactly the same.

So, unless you can explain why a formulaic approach, which will automatically take account of any changes to the data, isn't suitable, whereas a VBA one wouldn't necessarily be so flexible, I don't propose to spend any more time on this.

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