Sorting from a list with data on different cells

[Kiran]

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

 

[Anne Troy]

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

 

[David McRitchie]

Hi Kiran,
To permanently add the missing data into the cells see
for a worksheet solution see
Replicate values into blank cells (#fill_empty)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#fill_empty
for a maro solution see immedately below that the Fill_empty
macro. Since you will be sorting you can leave out the boldface

If these techniques are new to you, you should practice on test
data or on a copy of the worksheet as test data.