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.