Possibly using a pivot table you can get what you want.

--
Regards,
Tom Ogilvy


Ed wrote in message
...
Suppose I have one view of the data with the following columns:

NAME | YEARS OF SERVICE | SALARY | DEPARTMENT

I have this data in "Worksheet 1" sorted by Name, is there a way to
automatically generate other views of this data where each worksheet has
these data sorted by different columns (e.g. by YEARS OF SERVICE, by
SALARY,
by DEPARTMENT)?

Thanks.