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