software

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 quot;attachedquot; or together w/ the first row of this quot;groupquot;.

Thanks for any help. It is always appreciated.
jeff
jeff,

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

Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftwarequot;jeffPquot; gt; wrote in message
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 quot;attachedquot; or together w/ the first row of this quot;groupquot;.

Thanks for any help. It is always appreciated.
jeff