Try this:

Select the entire range of data, including the column headings (State,
Customer, etc)
From the Excel main menu: <Data<Sort
First "Sort By" dropdown should list the column headings
(If it doesn't, Check: My list has: Header Row)

Select: State from the list
Check: Ascending (or descending)
Click the [OK] button

The list will sort by state and all corresponding data for each row will
move accordingly.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"HHoosier" wrote:

I need to sort a rather large data base. Coulmns are State, Customer,
Product, Product Size etc. The entries currently are in order of invoice.

I need to start by sorting by state, keeping all information together
(State, customer ,product, product size etc.) just as it appeared in
origional data base but now sorted by State vs Invoice.

Thanks in advance