Sort a database

[Guest]

Using excel as a database I need to sort connecting rows. A1 has Vendor#, l
B1 has Vendor name, B2 has vendor address, B3 has phone #.
Each Vendor # may have anywhere from one row to 5 rows of info w/ only the
first row identified by Vendor#.
My question is : how can I sort this by vendor number keeping the related
rows "attached" or together w/ the first row of this "group".

Thanks for any help. It is always appreciated.
jeff

 

[Jim Cone]

jeff,

Take a look at this from John Walkenbach...
http://www.j-walk.com/ss/excel/usertips/tip040.htm

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


Using excel as a database I need to sort connecting rows. A1 has Vendor#, l
B1 has Vendor name, B2 has vendor address, B3 has phone #.
Each Vendor # may have anywhere from one row to 5 rows of info w/ only the
first row identified by Vendor#.
My question is : how can I sort this by vendor number keeping the related
rows "attached" or together w/ the first row of this "group".

Thanks for any help. It is always appreciated.
jeff