keeping a column in numerical order on workbook_change

[hc]

I need a simple Worksheet_Change macro that will do the following:

A            B
January      1
.
.
.                <-- variable amount of rows
.
January      2
.
.
January      3   <-- variable amount, but always from 1 onwards
.
.
.
February     1
.
. 
February     2
.
.
February     3
.
.
March        1
.
.
.
etc. for the entire year

- If at any time I delete the lines that make up January 2, then January 3 must automatically become January 2, February etc. must remain as is.

- If I delete January 1, then January 2 must become January 1 and January 3 must become January 2.

- If I delete February 3, then do nothing.

Thank you.

 

[hc]

That's exactly what I wanted.

Thank you.

 

[Von Pookie]

For continuation, please see: http://www.mrexcel.com/board2/viewtopic.php?t=75058