Kiran: Start by creating a "database". Put the name in EVERY cell, not just
the first cells. Then you can use autofilter and subtotals features to see
summaries of the information.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Kiran" wrote in message
...
Hi,
How can sort alphabetically a list of data present on different cells.
Ex: A6 = Scott
A10 = John
A14 = Abrahim
I am creating a call log list. with clientname, Date and messages fields.
There can be one client name, multiple dates and messages rtelated to each
date.
Ex:
Scott 6.6.05 Test msg
6.7.05 called again
John 1.1.05 adfasfda

Now I want to sort by the client name.

Now I want this list to be sorted without breaking the cloumns next to it.
Can this be done?
Also how can I make the message field automatically expand if more lines
of
space is needed. With my current design I am merging two rows for eacg
msg,
But its unpredictable how long the message can be?

Thanks
Thanks