Well, to clarify, I used a macro because in one case, the number sequence
only needed to go from 1-4 and was part of a longer process. But in other
cases, I have to fill in much longer repeating sequences.

Basically, I'm inserting a column and filling in these number sequences by
cutting and pasting at the moment, but I'd prefer to automate the process if
possible. The "IF" equation was the only thing that came to mind, but it
won't work for sequences of the size I'm needing.

The size of the sequence varies by the number of rows of information. For
example, I might have to divide the total number of rows by 500 and then
insert a sequence from 1 to whatever the result of the division is. (Sorry --
that probably sounds more confusing than it is.)

"Dave O" wrote:

Can you provide some more information: where does the information come
from, why is a macro with nested IF statements required, maybe examples
of your desired outcome? Most simplistically, if your number sequence
is in cell A1:A5, and that sequence needs to repeat, you could have a
formula in A6 that refers to A1. But it sounds like your application
is much more complicated than that.