Sort/Hide

[Cara]

Is there a way to set up a macro or other automated
procedure that will sort data by a particular method?

I share a spreadsheet with another department and we both
use it extensively, each with different data entry needs.
I would like to set up two sort methods (possibly macros,
I'm not sure) one for me, one for them, that will both
sort the rows, and hopefully sort/hide certain columns.
(Example, for me it would be sorted by number, hiding
columns C and D, and for them, it would be sorted by city,
hiding columns E and F.)That way, any time we open the
spreadsheet, we can easily adjust it to our own needs,
while keeping the data intact. (Using Office XP, Excel
2002)

Thanks!

 

[Dee]

I'm not sure about the sorting aspect, but you can create
custom views so that you will select the view that hides
the columns you don't want to see, while the other
department has a different view hiding different columns.

Set your spreadsheet to how you want it to look and then
select:

View / Custom Views... / Add [give it a name]

This creates a list of views that you can later go into
and select.

Dee
Reston, VA