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=5I hope it is clear, let me know and really thank you in advance.

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.

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History