View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf MyVeryOwnSelf is offline
external usenet poster
 
Posts: 213
Default How do I create a list of sequential numbers in Excel 2003?

I need to print on 3 x 5 cards columns of sequential numbers. I have
set up a print area so that the columns fit neatly on the card. It's a
pain to type the numbers in manually, but they do not exist in a
database. Is there a formula for typing in the first number in the top
left cell and the ending number in the bottom right cell, and the
program automatically filling in the columns with the correct numbers?


Maybe something like the csv file below would help.

Notice that if all the numbers are sequential integers only the first need
be typed in.

--------------- cut here --------------
95014,=A1+10,=B1+10,=C1+10,=D1+10
=A1+1,=A2+10,=B2+10,=C2+10,=D2+10
=A2+1,=A3+10,=B3+10,=C3+10,=D3+10
=A3+1,=A4+10,=B4+10,=C4+10,=D4+10
=A4+1,=A5+10,=B5+10,=C5+10,=D5+10
=A5+1,=A6+10,=B6+10,=C6+10,=D6+10
=A6+1,=A7+10,=B7+10,=C7+10,=D7+10
=A7+1,=A8+10,=B8+10,=C8+10,=D8+10
=A8+1,=A9+10,=B9+10,=C9+10,=D9+10
=A9+1,=A10+10,=B10+10,=C10+10,=D10+10