I would like to know if the AutoFill can copy an X amount of cells, skip an X
amount and then resume to copy another set of cells. (Ex: I want to copy
the first 5 cells skip the next 5 and then copy the next 5 all based on a
criteria).

Is there a way to create that type of pattern with the autofill. Is there a
way to do that with a Macro?

Thanks,