Hi all,
What I want to do is to take a long 2-column sorted list of data points
like this:

[Name | age]

and then arrange the data into multiple columns on pages and then sort on
just the names keeping the ages correct with the names (see below).

[Allen | 32 ]
[Beth | 12 ]
[Jim | 8 ]
[Judith | 40 ]
[Keith | 32 ]
.....
[Zack | 21 ]
(this has been, say, 500 names)

I then want to put this into Excel pages with 8 columns
[name1 |age1 |name31 |age31 |name61 |age61 |name91 |age91 ]
[name2 |age2 |name32 |age32 |name62 |age62 |name92 |age92 ]
[name3 |age3 |name33 |age33 |name63 |age63 |name93 |age93 ]
.......
[name30|age30|name60 |age60 |name90 |age90 |name120|age120]

and then continue to the next page with [name121|age121] ... until all of
the data are included.

Then when I add another [name |age] (at the end) or delete a [name | age ]
(anywhere), I need to be able to sort the list so that it falls into the same
pattern I've set up (removing the deleted data points, remaking the columns,
with names in correct alphabetical order).

Is there a way to easily do this in Excel 2003?

Many thanks,
Bob