I am having trouble with excel not ascending correctly
 

I am randomly entering data in previously created Transmittal log, as I get
it, and after I am done I want the area that say\'s weld number to all be in
numerical order by number not by date. I hit sort ascending and it puts that
row in order but all of the other rows end up all over the place. I need to
be able to hit ascend and have everything move into the write order. The
dates dont have to be in order only the weld numbers from low to high.
Hopefully you understand my dilemma and can help. If I could upload the excel
format to you that I am using, it probably would be more clear as to what I
am doing.Please e-mail me back. Thanks

I am having trouble with excel not ascending correctly
 

Rob

Don't let Excel guess your data range.

Select all columns and rows in your range then sort on one column.


Gord Dibben Excel MVP

On Mon, 21 Nov 2005 12:23:18 -0800, "Rob rock" <Rob
wrote:

I am randomly entering data in previously created Transmittal log, as I get
it, and after I am done I want the area that say\'s weld number to all be in
numerical order by number not by date. I hit sort ascending and it puts that
row in order but all of the other rows end up all over the place. I need to
be able to hit ascend and have everything move into the write order. The
dates don’t have to be in order only the weld numbers from low to high.
Hopefully you understand my dilemma and can help. If I could upload the excel
format to you that I am using, it probably would be more clear as to what I
am doing.Please e-mail me back. Thanks

I am having trouble with excel not ascending correctly
 

Rob rock wrote:
I am randomly entering data in previously created Transmittal log, as I get
it, and after I am done I want the area that say\'s weld number to all be in
numerical order by number not by date. I hit sort ascending and it puts that
row in order but all of the other rows end up all over the place. I need to
be able to hit ascend and have everything move into the write order. The
dates dont have to be in order only the weld numbers from low to high.
Hopefully you understand my dilemma and can help. If I could upload the excel
format to you that I am using, it probably would be more clear as to what I
am doing.Please e-mail me back. Thanks

Check this site provided by David McRitchie:
http://www.mvps.org/dmcritchie/excel/sorting.htm

gls858

I am having trouble with excel not ascending correctly
 

I select the single cell that I want to sort hit CNTL-A, and then ascend
nothing happens or the same problem happens everthing is all over the place.
I wish I could e-mail my program so someone could help me with the file in
front of them.

"Gord Dibben" wrote:

Rob

Don't let Excel guess your data range.

Select all columns and rows in your range then sort on one column.


Gord Dibben Excel MVP

On Mon, 21 Nov 2005 12:23:18 -0800, "Rob rock" <Rob
wrote:

I am randomly entering data in previously created Transmittal log, as I get
it, and after I am done I want the area that say\'s weld number to all be in
numerical order by number not by date. I hit sort ascending and it puts that
row in order but all of the other rows end up all over the place. I need to
be able to hit ascend and have everything move into the write order. The
dates dont have to be in order only the weld numbers from low to high.
Hopefully you understand my dilemma and can help. If I could upload the excel
format to you that I am using, it probably would be more clear as to what I
am doing.Please e-mail me back. Thanks

I am having trouble with excel not ascending correctly
 

Rob

Send it me if you wish.

Change the AT and DOT to appropriate puctuation in my email address.


Gord

On Mon, 21 Nov 2005 19:21:02 -0800, "Rob rock"
wrote:

I select the single cell that I want to sort hit CNTL-A, and then ascend
nothing happens or the same problem happens everthing is all over the place.
I wish I could e-mail my program so someone could help me with the file in
front of them.

"Gord Dibben" wrote:

Rob

Don't let Excel guess your data range.

Select all columns and rows in your range then sort on one column.


Gord Dibben Excel MVP

On Mon, 21 Nov 2005 12:23:18 -0800, "Rob rock" <Rob
wrote:

I am randomly entering data in previously created Transmittal log, as I get
it, and after I am done I want the area that say\'s weld number to all be in
numerical order by number not by date. I hit sort ascending and it puts that
row in order but all of the other rows end up all over the place. I need to
be able to hit ascend and have everything move into the write order. The
dates don’t have to be in order only the weld numbers from low to high.
Hopefully you understand my dilemma and can help. If I could upload the excel
format to you that I am using, it probably would be more clear as to what I
am doing.Please e-mail me back. Thanks