Auto Insert and Number Row based on an value input

March 23, 2012 at 22:33:11
Specs: Windows XP
Hi all,
I need help generate certain numbers of rows and number them.
let say A1 =10, then I would want
B1=1
B2=2
B3=3
B4=4
B5=5
B6=6
B7=7
B8=8
B9=9
B10=10
If A1 value is 5, then B1=1,B2=2.B3=3,B4=4,B5=5

I hope it is clear, let me know and really thank you in advance.


See More: Auto Insert and Number Row based on an value input

Report •


#1
March 24, 2012 at 12:01:50
Put this in B1 and drag it down as many rows as you need to cover the maximum number that A1 will ever be.

Worst case, fill the entire Column B with it.

=IF(ROW()>$A$1,"",ROW())

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question