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