One way to go along your thought process, rather than attempting to put all
1200 rows into columns via the transpose, do only on the ones that you are
actually planning on sorting as well as a column for keeping track of what
column numbers the data is corrently on.
Once the key columns has been sorted with the column that contain the column
number of the column each of those records are in, you can then have it go
down the list and pull in the column number to copy that particular column
data into a new worksheet column by column.
About the only other way I can think of to get around it is to build a
couple of class objects, one for each individual with the various
properties, and the other as a collection of all of those individual class
objects. Similar to how the Worksheets collection object contains all of
the individual worksheet objects. However, that's more involved, so not
sure if you want to get into that sort of effort or not.
Ronald R. Dodge, Jr.
Master MOUS 2000