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.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Orion" wrote in message ...
Hello,

is it somehow possible to sort something like this:

37/05
39/05
147/03
44/05
48/05
264/04
42/05
41/05
43/05
45/05
41/04
47/05
251/04
258/04
46/05
42/05

The 2 digit to the right of the slash is the year
The digits to the left of the slash are consecutive numbers, starting
with "1" for each year.

Can this be sorted, so that the last entry is on top and the first
entry is at the bottom?

Thanks for any help

Regards,
Norbert