You can use a macro, but you don't need to.

You can use AutoFilter instead. Click on the column and:

Data Filter AutoFilter Contains ABCD

this will hide the rows that don't contain ABCD in the desired column. Copy
the visible rows and paste eslewhere.
--
Gary''s Student - gsnu200909


"Rosscoe" wrote:

I would like to create a new sheet based on specific data from an existing
sheet using key text from cells in a column. I need to search a column range
and if the key text appears then I want to copy that whole row of information
into a new sheet.
For instance, if one cell, or several cells, in column range, say J2:J455,
contain the text "ABCD" then I would like to take that whole row of data, say
A5:M5, and copy it into a new sheet. What formulas do I need to contruct to
do that or does a 'macro' need to be written to do it?