Thanks, I will take a look and see if it works and let you know.
Allenc

"galimi" wrote:

I have place an example at http://www.HelpExcel.com/examples

The name of the spreadsheet is copyRow.xls
--
http://HelpExcel.com




"Allenc" wrote:

I have an Excel worksheet with 20+thousand products listed on it. I need a
formula that would search the column labeled Category for a specific word and
copy the row to a separate worksheet without having blank rows. I have about
a dozen categories that I need in separate sheets.
I am not an expert at this yet, so any help would be appreciated.

Thanks,

Allenc