I'm not sure that I completely understand you question correclty but you
could try playing with pivot tables to do what you want. However, the name
in column 1 would have to be on every line that name is associated with. You
could write a short macro to do it though if you have 90 pages worth. It
would look like the below:

Sub InsertName()
Dim Cell As Range
For Each Cell In ThisWorkbook.ActiveSheet.Range("A1:A1000").Cells
If Cell.Value = "" Then
Cell.Value = Cell.Offset(-1, 0).Value
End If
Next Cell
End Sub

Substitute the range of names in place of A1:A1000. Ensure you place the
macro in the workbook that the names are in and that you run it from the
worksheet you want it to run on (or adjust the macro accordingly).

Make a copy of your workbook before you try this.

Hope this helps.

Bill Horton

"Stephanie" wrote:

I am looking for a way to be able to group data on subsequent rows together
and then sort those groups into a list. My data looks something like this:

(Column 1) (2) (3) (4) (5)
Smith, Joe 1 2 3 A
5 6 B

Doe, John 1 2 3 A
5 6 B

Doe, Jane 1 2 3 B
6 5 A
7 8 9

I need to be able to group each "person" in column 1 together with the data
in the next 4 columns and following rows. Then I need to sort the groups so
that every "person" with a "3" in the 4th column together. See what I mean?
Can I do this and if I can, how?
Thanks!