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?