How do I create a list of sequential numbers using Excel or Acces.

[Guest]

I am trying to generate a list of numbers, incrementally increased to my
specifications. I absolutely hate the idea of having to do these
myself....is there a way to have Excel or Access generate this list for me?

 

[David McRitchie]

There are all kinds of ways of doing this, but what are your
specifications, and restrictions.

Increment by one
insert a 1 into cell A1 or a formula =ROW() into cell A1

place 1 into cell A1, drag down with right mouse button, fill series

place =ROW() * 5 - 1 into cell A1
drag down with mouse, or
drag down with right mouse button, fill values (still be formulas)

If you have a value to the left, or if none then cells with values on the right,
you can double click to fill-down, more information on
use of the fill handle in
http://www.mvps.org/dmcritchie/excel/fillhand.htm

Then, of course, if you know what you want and where you want it
you could do it in a macro.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm