Formula needed for Skipping Column

[janx]

I tried searching, but it's going to make my brain explode trying to figure this out.

I have a workbook, lets say with sheet1 and sheet2, ... I need a formula (=index I'm pretty sure on) on sheet2 for referencing k12 on sheet1 and then skipping every other column, K12, M12, O12, ..etc

Thank you

[incidentals]

can you explain what you are doing with every other column

I cannot get my head around your question

[janx]

So on sheet1 I have a sum from rows K4-K11 at K12, this is repeated at L M O Q on line 12 as well, basically every other column.

What I want is a formula on sheet 2 that will place the row 12 information starting at C6 in each column, C6, C7, C8,and onward, but the value's are from sheet1 every other column, and sheet2 does not skip columns..

[davsth]

It is not clear but if c6=k12, c7=m12, c8=o12 etc

perhaps

=OFFSET(Sheet1!$I$12,0,ROW(A1)*2) in c5

[janx]

Thanks Davsth... now when I drag the lower right corner its just using the same data for each box?