I don't think you can copy down to get those sequencies.

One thing you can do is use formulas to get the sequences.

e.g.

In A2:

="Claire & David "&TEXT(MOD(INT((ROW()-ROW($A$2))/6),6)+1,"000")

copied down as far as needed

then in B2:

=5593+MOD(INT((ROW()-ROW($A$2))/6),6)

copied down same distance.

You can then copy those 2 columns and paste special >> Values over themselves to eliminate the formulas and get them hard-coded.

## Bookmarks