I'm using Excel 2007 and the following works for me (manually and/or via VBA
coding).

Use a filter to limit your data, copy the filtered data and paste it into
your new worksheet.

Good Luck.

"Gordon" wrote:

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