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.

Pebbbles wrote:
>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.

--
Joseph Meehan

Dia duit

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

"Joseph Meehan" wrote:

> Pebbbles wrote:
> >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.
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>