LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Sylvia
 
Posts: n/a
Default Can't Change and Re-Sort

I have a spreadsheet that has many columns, some of which I am trying to sort
by. One Column is called Closed Date, and is in Date Format. Another column
is called Referred Date and is in Date Format. And another is called Status
and is in General Format. I am sorting the spreadsheet first by Closed Date,
then by Referred Date, then by Status. It sorts fine. nIf I correct a date
and re-sort, it re-sorts fine. BUT, if I correct a date and a status, it
does not re-sort correctly...the changed records is at the bottom of the
spreadsheet out of the sort sequence. I just can't figure out what is
happening and why it won't re-sort. HELP!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel change default column sort to current selection john palmer Excel Worksheet Functions 2 March 8th 05 03:07 PM
How do I link two cells as to allow me to change the value in eit. jpvlvt Excel Discussion (Misc queries) 3 January 26th 05 01:28 AM
how do i make a date change automatically if i change one before . dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:21 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM
Why does a formula change when I sort a column pdhay Excel Worksheet Functions 1 December 9th 04 04:31 PM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"