I need to copy numbers from 1 to 100 in the same column repeating each number 5 times before moving to the next number .
like
1
1
1
1
1
2
2
2
2
2
till 100
Please help
I need to copy numbers from 1 to 100 in the same column repeating each number 5 times before moving to the next number .
like
1
1
1
1
1
2
2
2
2
2
till 100
Please help
Re: Vba code to copy values down in the same column
Arm, as you can see, duplicate threads gets very confusing
See your other thread also....
nice solution Ger Plante
Re: Vba code to copy values down in the same column
See
[h=3]Fill cells down column x number of time with repeating numbers[/h]
Re: Vba code to copy values down in the same column
accidental double post here:
http://www.ozgrid.com/forum/showthread.php?t=164306
Ger
Re: Vba code to copy values down in the same column
Thanks Jproffer
Re: Vba code to copy values down in the same column
Hi All ,
Thanks for the solution ..it worked perfectly fine . Apologies for te double posting . Was the first time i was posting and hence the mistake . Will take care in future . Thanks everyone.
Don’t have an account yet? Register yourself now and be a part of our community!