Auto fill skip columns 2 diff sheets

[GMLuquis]

I need help. I have data in one sheet: column A = Expected column B = actual for the Day 1, column C = Expected and column D = actual for Day 2 and goes on... then row 2 is production line 1, row 3 production line 2, etc... in sheet 2 i want to calculate attainment results column A row 2 will be attainment for line 1 (Sheet1 columnB/columnA), row 3 will be attainment for line 2 (Sheet1 columnD/ColumnC), etc.

I want to drag my formula in sheet2 to the right to auto fill with the references in sheet1 without having to manually change the reference all the time (skip columns)

3-Apr 4-Apr 5-Apr
80% 63% 97%
=Sheet1!C4/Sheet1!B4 =Sheet1!E4/Sheet1!D4 =Sheet1!G4/Sheet1!F4

Thank you

[jason.b75]

Try something like

=INDEX(Sheet1!4:4,,(COLUMNS($B2:B2)-COLUMN($B2))*2+3)/INDEX(Sheet1!4:4,,(COLUMNS($B2:B2)-COLUMN($B2))*2+2)

All instances of B2 in the formula should refer to the first cell in which you will enter the formula before filling right. Please give special attention to the placement of the $ symbols.
The calculations at the end, *2+3 on the left and *2+2 on the right of the formula denote the pattern.
The multiplier sets the number of columns in the pattern. (*2 would give columns B,D,F,H, etc. *3 would give C,F,I,L, etc.)
The addition sets the startting column for the first pattern (+1 starts in column A, +5 starts in column E).

The formula above will follow the pattern in your question, starting at C4/B4

[GMLuquis]

Awesome! Thank you