Hi,

I have a worksheet full of data and wish to display all the rows of a certain catagory on a seperate sheet.

The problem is, there could be any number of rows in each catagory.

I know by Auto-filtering the data I can just show the data relateing to a specific catagory, but is it possible to show this filtered data on a seperate worksheet?

Thanks.