if you're talking about named ranges, this page explains how to create a
dynamic named range
http://www.contextures.com/xlPivot01.html

if you want the numbering in column C to adjust to value in $a$1 this
formula in C5 should do da trick:

=if(c4+1$a$1,"",c4+1)

then copy down as many rows as you think the maximum possible value would be
in $a$1, hope that helps


"Avi Dubnikov" wrote:

Hi,
How do I create a range of rows dynamically based on a number in a given cell. For example
in $A$1 the value is 12.
In C4 the value is 1. What I want to do is create more rows in column C based on the value in $A$1. The values in column C
should be 1,2,3 etc. Any time I change the value of $A$1 the number of rows with values should be changed accordingly.
Thanks
---
Avi D