Dynamically create range of rows
 

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.

Dynamically create range of rows
 

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

Dynamically create range of rows
 

Hi,
Thanks. That helped.
AD
"mwam423" wrote in message
...
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