I want to be able to do a report from a single worksheet which will show

The top 10 items
Bottom 10 items

I can use autofilter but autofilter only does one at a time and does it in
the worksheet itself.

I want to be able to show the top and bottom 10 on a seperate list.

Any ideas how this can be done.

Thanks