Auto sort data??

[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 "macros" or sort methods, one
for me, one for them, that will both sort the rows, and
hopefully sort/hide certain columns. 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!
Cara