Hi David,

I do not understand what you mean with turning the list upside down.
It is not sorted yet.
Anyway, thanks for your help.

Norbert



On Tue, 8 Mar 2005 06:26:09 -0500, "David McRitchie"
wrote:

I'm sure I've misunderstood the question because you tried to
describe what the data is, but the only question I see is turning
the list upside down.

B1: 1 B2: 2 use the fill handle to copy down,
sort the entire sheet on column B descending.

If you want a macro to reverse only those cells (top to bottom), see
http://www.mvps.org/dmcritchie/excel/join.htm#reversi
It actually reverses any rectangular selection.