Hi guys

I have a data sheet which has columns (name,x,z,f,w,cat). each row has a value for name, a value for x,z,f,w,cat.
There are over 100 rows
The values for column cat are one of the three (Cat. I, Cat. II, Cat. III)
So if the value in column "cat" is Cat. I i want the entire row to be copied to a new worksheet named Cat. I

Values for x,z are not important so I want worksheet Cat. I to look like this

Name1 Name2 ..................
F W F W ..................

Thanks
MHJ