If the first, say, 100 numbers are in A1:A100, to repeat those numbers in
A101:A200, just use this formula in A101 and copy it down: =A1

On Thu, 31 Mar 2005 10:07:04 -0800, "Nexan"
wrote:

Is there a way to automatically set up a repeating number sequence in a
column? I've figured out how to do it with sequences of up to 7 numbers using
nested "IF" formulas in a macro, but as I understand it, that's as many
nested formulas as Excel can handle. I'd need repeating sequences up to three
digits in some cases.

Thanks!