sort problem

[derekc]

i have a sheet with 6 colums

REC # - CUST - PART NUMBER - PL - QTY HND - WHSE QTY

4325 - 1312 - 1105533 - 5 - 0 - 0

i want to sort this info by part number. i want the part number t
start on top as smallest part number to biggest. if i just sort th
column the rest of the data stands still, i knew that, but i cant fin
out how to get the rest of the data to sort with it. i basically nee
to sort the info by part number and keep the rows together. so all th
info is correct.sort the rows by the info in one column. something i
that natur

 

[Guest]

You need to expand the selection so that the other columns are order
according to Part Number as well.

That's all there is to it.

Robert

 

[derekc]

appreciate the help got it going but now im getting an error

The sort reference is not valid. Make sure that it's within the data
you want to sort, and the first sort box isnt the same or blank. i put
a macro into a button that si also doing other things. ive wewnt through
every possiblity i can think of? this is what i have

ActiveSheet.Range("B2:B905").Select
Selection.Sort Key1:=Range("B2"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom


thats from the macro i ran, for some reaosn it wont work only if i run
as macro?