Automation for filling in sets of numbers in each row
Posted
by
Brad
on Super User
See other posts from Super User
or by Brad
Published on 2012-10-22T00:09:00Z
Indexed on
2012/10/22
17:05 UTC
Read the original article
Hit count: 184
microsoft-excel
I need to populate the same number 10 times in a row, then the next number up on the next row.
starting at 0, ending at 1000
for example:
1 1 1 1 1 1 1 1 1 1
2 2 2 2 2 2 2 2 2 2
3 3 3 3 3 3 3 3 3 3
....
1000 1000 1000 1000 1000
and to 1000
I need to print out these numbers to cut up and put each row of numbers in each envelope to be sold for a Chinese auction at a benefit.
How do I do this dynamically without entering in all of the rows by hand?
© Super User or respective owner