Dynamically create range of rows

[Avi Dubnikov]

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

 

[Guest]

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]

Hi,
Thanks. That helped.
AD

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