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.

Rack ID (left side bay if possible)	Number of levels (0-10)	Level ID (A-J)
Bay to left	10
		A
		B
		C

<colgroup><col><col><col></colgroup><tbody>
</tbody>

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