How do I auto sort to multiple worksheets?

[Guest]

I have a work sheet that I regularly sort by different columns and then save
that version. I'd like to have the data from my master sheet auto sort to
these new sheets. For example, the master sheet has customers, buildings,
orders and vendors. The master is saved chronilogically. I'd like to auto
sort by building to one sheet, by customer to another sheet and so on. I am
using Excel 2003. Thanks.

 

[Joseph Meehan]

I have a work sheet that I regularly sort by different columns and
then save that version. I'd like to have the data from my master
sheet auto sort to these new sheets. For example, the master sheet
has customers, buildings, orders and vendors. The master is saved
chronilogically. I'd like to auto sort by building to one sheet, by
customer to another sheet and so on. I am using Excel 2003. Thanks.

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

 

[Guest]

Thanks. I thought I saved for Excel. Will try again