alternate sort on different columns

Revontulet

Guest

Posts: n/a

2nd Mar 2010

I try to sort a spreadsheet (Excel 2003) alternatively in two different ways,
independent of each other.
It means, if a certain condition is met, the data should be sorted on column
A, if the other condition is met, it should be sorted on column D.
Right now I have the problem that Excel remembers the previous sort (that
is, if I first sorted on column D, the next sort on column A keeps the
previous sort on D - which I don't want.
How can I undo the previous sort?
Aurora

« What is Selected? | Printing App »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I alternate a sort from a text box via macros?	=?Utf-8?B?Zy5hLg==?=	Microsoft Excel Programming	1	9th Jun 2005 11:26 PM
How do I alternate a sort from a text box via macros?	=?Utf-8?B?Zy5hLg==?=	Microsoft Excel Programming	0	9th Jun 2005 06:03 AM
Button Code to Alternate Sort Order ?	Paul Cross	Microsoft Excel Programming	1	13th Nov 2004 12:37 AM
Excel Sort - Alternate Sequence	Stan	Microsoft Excel Worksheet Functions	1	9th Jul 2004 03:30 PM
Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns?	William.R.Reisen	Microsoft Access External Data	2	20th Dec 2003 02:23 AM