(Msg. 1) Posted: Fri Jan 26, 2007 6:41 am
Post subject: Is there a way to Auto sort or save a sort? Archived from groups: microsoft>public>excel>misc (more info?)
Is there a way to create a spreadsheet that retains the default sort order,
so that new information added to the bottom of the spreadsheet will
automatically be moved into the proper position within the saved sort?
(Msg. 2) Posted: Fri Jan 26, 2007 9:40 am
Post subject: Re: Is there a way to Auto sort or save a sort? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Personally, I don't like things too automatic. I'm afraid that if I enter
incorrect data, it could sort to whoknowswhere and it would take forever to find
and correct it.
But I don't like doing the same thing over and over again, either.
In xl2003, you can apply data|filter|autofilter to the range and use the
dropdown arrow to sort your data.
Debra Dalgleish has a technique at her site that adds invisible rectangles in
the headers and then sorts the data by that field when you click on one of those
rectangles.
Barbie wrote:
>
> Is there a way to create a spreadsheet that retains the default sort order,
> so that new information added to the bottom of the spreadsheet will
> automatically be moved into the proper position within the saved sort?
(Msg. 3) Posted: Fri Sep 05, 2008 7:05 am
Post subject: Re: Is there a way to Auto sort or save a sort? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Is there a way to create a spreadsheet that retains the default sort order
for Xl2007? I have to recreate the same sort everyday for a spreadsheet and
the information is almost identical on a day to day basis. I receive an
email in .rtf and then copy and paste to XL and then sort. The information
changes slightly from day to day and it is tiresome having to recreate every
sort and it is only 3 columns that are being sorted.
"Dave Peterson" wrote:
> Personally, I don't like things too automatic. I'm afraid that if I enter
> incorrect data, it could sort to whoknowswhere and it would take forever to find
> and correct it.
>
> But I don't like doing the same thing over and over again, either.
>
> In xl2003, you can apply data|filter|autofilter to the range and use the
> dropdown arrow to sort your data.
>
> Debra Dalgleish has a technique at her site that adds invisible rectangles in
> the headers and then sorts the data by that field when you click on one of those
> rectangles.
>
> http://contextures.com/xlSort02.html >
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm >
> Barbie wrote:
> >
> > Is there a way to create a spreadsheet that retains the default sort order,
> > so that new information added to the bottom of the spreadsheet will
> > automatically be moved into the proper position within the saved sort?
>
> --
>
> Dave Peterson
>
(Msg. 4) Posted: Fri Sep 05, 2008 10:30 am
Post subject: Re: Is there a way to Auto sort or save a sort? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
record a macro and run it each time.
Dorlynne Harris wrote:
> Is there a way to create a spreadsheet that retains the default sort order
> for Xl2007? I have to recreate the same sort everyday for a spreadsheet and
> the information is almost identical on a day to day basis. I receive an
> email in .rtf and then copy and paste to XL and then sort. The information
> changes slightly from day to day and it is tiresome having to recreate every
> sort and it is only 3 columns that are being sorted.
>
>
> "Dave Peterson" wrote:
>
>
>>Personally, I don't like things too automatic. I'm afraid that if I enter
>>incorrect data, it could sort to whoknowswhere and it would take forever to find
>>and correct it.
>>
>>But I don't like doing the same thing over and over again, either.
>>
>>In xl2003, you can apply data|filter|autofilter to the range and use the
>>dropdown arrow to sort your data.
>>
>>Debra Dalgleish has a technique at her site that adds invisible rectangles in
>>the headers and then sorts the data by that field when you click on one of those
>>rectangles.
>>
>>http://contextures.com/xlSort02.html
>>
>>If you're new to macros, you may want to read David McRitchie's intro at:
>>http://www.mvps.org/dmcritchie/excel/getstarted.htm
>>
>>Barbie wrote:
>>
>>>Is there a way to create a spreadsheet that retains the default sort order,
>>>so that new information added to the bottom of the spreadsheet will
>>>automatically be moved into the proper position within the saved sort?
>>
>>--
>>
>>Dave Peterson
>>
(Msg. 5) Posted: Fri Sep 05, 2008 10:35 am
Post subject: Re: Is there a way to Auto sort or save a sort? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Not that I know.
If I had to do it, I'd record a macro when I did it manually. Then I'd store
that macro in a different workbook (not the .rtf) and just open that workbook
with the macro whenever I needed to sort the data.
Dorlynne Harris wrote:
>
> Is there a way to create a spreadsheet that retains the default sort order
> for Xl2007? I have to recreate the same sort everyday for a spreadsheet and
> the information is almost identical on a day to day basis. I receive an
> email in .rtf and then copy and paste to XL and then sort. The information
> changes slightly from day to day and it is tiresome having to recreate every
> sort and it is only 3 columns that are being sorted.
>
> "Dave Peterson" wrote:
>
> > Personally, I don't like things too automatic. I'm afraid that if I enter
> > incorrect data, it could sort to whoknowswhere and it would take forever to find
> > and correct it.
> >
> > But I don't like doing the same thing over and over again, either.
> >
> > In xl2003, you can apply data|filter|autofilter to the range and use the
> > dropdown arrow to sort your data.
> >
> > Debra Dalgleish has a technique at her site that adds invisible rectangles in
> > the headers and then sorts the data by that field when you click on one of those
> > rectangles.
> >
> > http://contextures.com/xlSort02.html > >
> > If you're new to macros, you may want to read David McRitchie's intro at:
> > http://www.mvps.org/dmcritchie/excel/getstarted.htm > >
> > Barbie wrote:
> > >
> > > Is there a way to create a spreadsheet that retains the default sort order,
> > > so that new information added to the bottom of the spreadsheet will
> > > automatically be moved into the proper position within the saved sort?
> >
> > --
> >
> > Dave Peterson
> >
(Msg. 6) Posted: Tue Nov 04, 2008 1:12 pm
Post subject: RE: Is there a way to Auto sort or save a sort? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I am too in need of some automatic formula to not only auto sort every time I
add a row to the spreadsheet or update my indicator but also to do a subsort
within the indicator sections by date that is indicated in a specific column.
I don't mind doing a repeat each day but I have to do the first sort then
select the sub section, each one I need sorted and redo for the date because
it won't conserve the rows...anyway to avoid this?
--
Judy Rose Cohen
"Barbie" wrote:
> Is there a way to create a spreadsheet that retains the default sort order,
> so that new information added to the bottom of the spreadsheet will
> automatically be moved into the proper position within the saved sort?
(Msg. 7) Posted: Thu Jan 15, 2009 7:32 am
Post subject: Re: Is there a way to Auto sort or save a sort? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
We're looking for a way to keep the sort settings. We add a few lines each
day & now when we go to Data > Sort, we have to check "no header row" &
choose columns again. In previous worksheets, it seemed to keep the
settings. We use Excel 2003.
(Msg. 8) Posted: Fri Jun 05, 2009 6:44 am
Post subject: Re: Is there a way to Auto sort or save a sort? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I have tried this several times in Excel 2007 and it does not retain the sort
criteria. The macro method is how I did it with Excel 2003. Surprisingly,
the sort macros I used from 2003 still actually work. However, I can't
create new ones. Microsoft needs to create a "Save Sort" function.
"Bob I" wrote:
> record a macro and run it each time.
>
> Dorlynne Harris wrote:
>
> > Is there a way to create a spreadsheet that retains the default sort order
> > for Xl2007? I have to recreate the same sort everyday for a spreadsheet and
> > the information is almost identical on a day to day basis. I receive an
> > email in .rtf and then copy and paste to XL and then sort. The information
> > changes slightly from day to day and it is tiresome having to recreate every
> > sort and it is only 3 columns that are being sorted.
> >
> >
> > "Dave Peterson" wrote:
> >
> >
> >>Personally, I don't like things too automatic. I'm afraid that if I enter
> >>incorrect data, it could sort to whoknowswhere and it would take forever to find
> >>and correct it.
> >>
> >>But I don't like doing the same thing over and over again, either.
> >>
> >>In xl2003, you can apply data|filter|autofilter to the range and use the
> >>dropdown arrow to sort your data.
> >>
> >>Debra Dalgleish has a technique at her site that adds invisible rectangles in
> >>the headers and then sorts the data by that field when you click on one of those
> >>rectangles.
> >>
> >>http://contextures.com/xlSort02.html
> >>
> >>If you're new to macros, you may want to read David McRitchie's intro at:
> >>http://www.mvps.org/dmcritchie/excel/getstarted.htm
> >>
> >>Barbie wrote:
> >>
> >>>Is there a way to create a spreadsheet that retains the default sort order,
> >>>so that new information added to the bottom of the spreadsheet will
> >>>automatically be moved into the proper position within the saved sort?
> >>
> >>--
> >>
> >>Dave Peterson
> >>
>
>
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office