I don't follow. A loop to do what? Excel does the sorting on the
temporarily added sheet. You originally said you had 181 observations
on two sheets (thus 362 total). Now you say 414 or 400 observations.
Where are the extra ones? If you want to handle more observations,
adapt the hard-coded parts (worksheet names, columns, rows and array
size) of the macro I gave you. You could, of course, replace them with
variables, but you would have to give them specific values somehow.

Merjet