Sorting from a list with data on different cells

K

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top