Can you create new rows based on the number value in a column

[baionia]

So here is the situation that I am faced with making work.
We have a cell where when someone puts a number (1-10) it should create new rows labeled (A-J) based on the number in the cell.

[TABLE="width: 559"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Rack ID (left side bay if possible)[/TD]
[TD]Number of levels (0-10)[/TD]
[TD]Level ID (A-J)[/TD]
[/TR]
[TR]
[TD]Bay to left[/TD]
[TD]10[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]


I am trying to do this just straight excel rather than VBA.
Then end goal is for this to be able to work on a tablet or laptop.

Any help is appreciated

 

[Scott T]

Is this what you need? Copy the formula down. If you need to insert rows to make room then you will need to use VBA.

Book1
	A	B	C
1	Rack ID (left side bay if possible)	Number of levels (0-10)	Level ID (A-J)
2	Bay to left	10
3			A
4			B
5			C
6			D
7			E
8			F
9			G
10			H
11			I
12			J
Sheet1

Cell Formulas
Range	Formula
C3	=IF(ROWS(C$3:C3)>$B$2,"",CHAR(65+ROWS(C$3:C3)-1))

 

[baionia]

Scott,

You rock, I have been fighting with this for a couple days just not sure how to work it outright.
Thank You