software

I am putting a correspondence review in a big project. There are 7 columns:
Date, Form, From, To, , Comments, Pages. Information in some of the
columns contain multiple lines. What I want to do is, I want to put the
information in and finally sort them according to dates. How do I group all
information for a specific correspondence so that when I sort all information
will be attached to the date. Thank you.

Seems like you have the date in the first column.
If not, it should be
Then select all cells: A2:G100
assuming your first date entry starts in A2 and is 100 rows down by 7
columns wide)
select the quot;sort -Ascending or Descending- iconquot; on the toolbar ( A over
Z with an arrow to it's right).
HTH

quot;ericsayangquot; wrote:

gt; I am putting a correspondence review in a big project. There are 7 columns:
gt; Date, Form, From, To, , Comments, Pages. Information in some of the
gt; columns contain multiple lines. What I want to do is, I want to put the
gt; information in and finally sort them according to dates. How do I group all
gt; information for a specific correspondence so that when I sort all information
gt; will be attached to the date. Thank you.

The only way to keep a set of data like this together is to have one column that
contains data common to all rows in that set.
Col A ColB

Date1 data3
data2
data1
Date2 data5
data4
data6

These rows will not stay together when sorted by date.

You must enter the date on each row and sort by that column

Date1 data3
Date1 data2
Date1 data1
Date2 data5
Date2 data4
Date2 data6To fill in the blank dates, select column A and F5gt;Specialgt;Blanksgt;OK

In active blank cell enter an = sign then point to the cell above and CTRL
ENTER to fill down.

Copygt;Paste Special(in place)gt;Valuesgt;OKgt;Esc to get rid of formulas.Gord Dibben MS Excel MVPOn Thu, 12 Jan 2006 08:15:02 -0800, quot;ericsayangquot;
gt; wrote:

gt;I am putting a correspondence review in a big project. There are 7 columns:
gt;Date, Form, From, To, , Comments, Pages. Information in some of the
gt;columns contain multiple lines. What I want to do is, I want to put the
gt;information in and finally sort them according to dates. How do I group all
gt;information for a specific correspondence so that when I sort all information
gt;will be attached to the date. Thank you.