I am having trouble with excel not ascending correctly

[Rob rock]

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

[Gord Dibben]

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
[email protected]> 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

[Rob rock]

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
> [email protected]> 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
>
>

[Gord Dibben]

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"
<[email protected]> 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
>> [email protected]> 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
>>
>>

[gls858]

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 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

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

gls858