Dragging across formulas on new sheet which references sheet with a space between each column

[joce]

Hello,

I have values on Sheet 1 which contain prices in every other column in row I starting with I128 (skip J128) value in M128 and so on with the last value being in column Q128.

I am attempting to put these values in a clean spreadsheet (Sheet 2) uniformly across in rows K14 through O14. I can't click and drag because of the space in between each value in spreadsheet 1. I would rather not put a space in between each value on the new spreadsheet 2 as it would take up too much space.

Please let me know if you know a solution to this problem.

Thanks,
Jocelyn

 

[Joe4]

Welcome to the Board!

Here is one way.
Put this formula in cell K14 and drag to O14:

=OFFSET(Sheet1!$I$128,0,(COLUMN()-11)*2)

 

[joce]

You're a lifesaver thank you

 

[Joe4]

You are welcome.
Glad I was able to help!