Automatic Generate Numbers based on already assigned letters

Originally Posted by bebo021999

So you want A1:Z6600 contain A-Z, and in, i.e, AA1:AZ6600 display 1-8?

Sorry if I am not clear with my question.

I have only one concern. If I type, say A or I, anywhere in the worksheet, their corresponding numbers should show next/below to them. Example, B29 = A, it should show 1 to B30 or C29.

B29 = A C29 = 1

or

B30 = 1

One more example, AC30 = R, it should show 2 to AC31 or AD30.

AC30 = R AD30 = 2

or

AC31 = 2

I hope this clarifies.