Sort a list with uneven row information
 

I have created a list of business card contacts with a number of columns.
Each contact also contains up to four rows of information i.e. "Address"
information (two or three rows for street address; apt/suite number; city,
state and zip), "Phone" information (with two three rows for cell phone,
telephone, fax), etc. etc.
When I attempt to "Sort" by "Ascending Order" the uneven rows of information
become separated and are placed at the bottom of the list, making the list of
very little use.
I have attempted to use a blank row between the contacts and have used no
blank row but the end result is the same.
I think there is a way to do what I want to do but I have run out of options
for trial.
Any help would be greatly appreciated.

Sort a list with uneven row information
 

newexceluser, not sure how you have the info set up but I would list the
contact names in column A,street, address in B, city in C...... using a new
column for each piece of information you might want to sort by, put in a
description for each column in row 1 and start you information in row 2,
this way you can sort or filter on any column you want

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"newexceluser" wrote in message
...
I have created a list of business card contacts with a number of columns.
Each contact also contains up to four rows of information i.e. "Address"
information (two or three rows for street address; apt/suite number; city,
state and zip), "Phone" information (with two three rows for cell phone,
telephone, fax), etc. etc.
When I attempt to "Sort" by "Ascending Order" the uneven rows of
information
become separated and are placed at the bottom of the list, making the list
of
very little use.
I have attempted to use a blank row between the contacts and have used no
blank row but the end result is the same.
I think there is a way to do what I want to do but I have run out of
options
for trial.
Any help would be greatly appreciated.