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

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

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...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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Anne Troy" wrote in message news:7b05a$42b9e95e$97c5108d$22240@allthenewsgroup s.com...
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