Insert Alphabet based on another cell... Harder than it sounds...

[Richard_mcr]

Hi All,

I'm building a calculation worksheet which involves inserting copied rows. I have what I imagine is an easy problem that I'm making difficult!

Senario:

Rows 1 to 5 are related to one set of data with a sequential letter reference. Each time I insert a new set, I copy and inset a defined additional 5 rows and the next alphabet letter; therefore I result in simple terms with:

A = Row 1 to 5
B = Row 6 to 10
C = Row 11 to 15
Etc...

At the moment, I have a validation on the letter cell and manually change the to the next letter.

Requirement:

Once the new 5 rows are inserted at the end of the data, I want to look at the cell with the letter in the previous set and select the next letter in the alphabet. The letter cell in each set is currently the second row, column B.

If anyone could point me in the right direction, I'd very much appreciate it!

 

[duggie33]

Something like this might work...

Book1
	E
1
2	A
3
4
5
6	B
7
8
9
10	C
11
12
13
14	D
15
16
17
18	E
19
20
21
22	F
23
24
25
Sheet1

Cell Formulas
Range	Formula
E6,E22,E18,E14,E10	E6	=IF(AND(CODE(E2)+1>=65,CODE(E2)+1<=90),CHAR(CODE(E2)+1),"-")

I hope that helps,

Doug

 

[Richard_mcr]

Hi Doug,

Sorry for the slow response!

Thanks for the code, however, I realise now that I didn't explain what I need correctly!

I need to do exactly what you have done, however, I need it to be a one time event. There will be a need a times to inset a new section, for example, in between C and D, but I wouldn't want D to automatically become E....

I hope that makes sense!!

Thanks again for looking at it!

 

[duggie33]

I am not sure how to do what you want. Entering it manually might be the best way.

Doug