Hi..

I have a block of data A9:10000 - X9:10000. Is there any code that would
allow me to select any combination of rows in which the word 'aged' is found
and then to compact them into a new sheet? For example, if the word 'aged' is
only found on 130 random rows then those 130 are pasted into a new sheet as
one block of text.

Any help would be appreciated...

Thanks G