Dragging across columns to the right is stepping backward in the cell references

On a single row, I've set up 33 consecutive columns exactly how they should be. I then highlight all 33 cells and drag the fill bar across.

I made if the attached sample. It shows the problem where A16:K16 is right.

However, dragging that pattern across results in K16 and L16 being the same while it does skip one column L16 to M16 which is what is needed. But the pattern is off because of L16.

It doesn't follow the pattern of skipping a column, it follows the pattern of the original range that you're dragging.

In each group of 11, the first formula returns row 8 of the same column, the rest return row 8, 1 column to the right.

The ultimate goal is to copy 63 sections like this and have them all lined up.

You could try a formula that allows for the adjustment

=INDEX(8:8,COLUMN()+(MOD(COLUMN(),11)<>1)+INT((COLUMN()-1)/11))

Failing that I think it's going to be VBA

Good effort. However, the formula isn't linking things up, and it's copying the unwanted field.

Might be some VBA or some HLOOKUPs and OFFESTs

I forgot to adjust the formula for your real data range, that was based on data starting in column A not AL Try

=INDEX(8:8,COLUMN()+(MOD(COLUMN(),11)<>5)+INT((COLUMNS($AL1:AL1)-1)/11))

oeldere, that's what I ended up doing. It took less than 10 minutes.