Your task description is ambiguous. For example, it's by no means clear what goes into A2:A10. Does each cell in A2:A10 get populated with 'Peter', or something else? If it's something else, where does the something else originate? And why do there appear to be 9 rows per person (Peter = A2:A10; Dave = A11:A19)? Do all entries have 9 rows, or only some? If only some, what are the criteria?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|