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: 161

Filed under:

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

Related posts about microsoft-excel