Sort data to other worksheets

[Ben Bazian]

Looking for a way to have a master worksheet that has approximately 10
colums by 400 rows. We constantly add rows to the sheet and then need to
view it sorted in various ways. Is there a way to have the data from the
master sheet displayed on other tabs in various sorts without copying the
data to the other worksheets every time data is added.

 

[Dave Peterson]

Maybe you can just apply Data|Filter|Autofilter and hide/show the data you want
to see.

 

[Ben Bazian]

But this will not allow me to sort the data, just filter it. I need to see
all date but in different sorts. Of course I can manually copy to the
additional worksheets and manually sort but that sounds kind of silly.
There has to be a better way.

Thanks

 

[Dave Peterson]

Sort your data the way you want, then filter to show what you want.

I've found that it's always easier to keep the data in one location.

You may like this technique to make the sorting easier:
http://contextures.com/xlSort02.html
from Debra Dalgleish's site.

By the way, xl2003 has a sorting option under the autofilter dropdown.