Hi

I wonder if someone can help.

I have two columns A and B. Column A is empty and column B is numbered 1
- 100.

What I need to do is this :

When I enter a number or a letter into A , I need B to react by
numbering from 1 onwards in the adjacent sells for each time a new
number or letter is entered.

So for example in cell A1 I have a number of a letter and B1 is number
one , going down to 100.

If then I enter a number or a letter in A10 , then B10 should become
number one and number down accordingly to the bottom.

If I put a number or a letter in sat A40 , then B40 should become number
one and number down consecutively to the bottom.


A B

A 1
2
3
4
5
B 1
2
3
C 1
2
3
4
5
6
7
D 1
etc

If content is removed from A then the cells in B should react
accordingly

Can this be done?

Grateful for any help.

Best Wishes


Colin