Help with Offset formula

[Guest]

I have two worksheets. The first worksheet has data in every 4th column ie a,
d, g, j, etc that I want to bring in to columns a,b,c,d etc on the second
sheet.

Using the offset function I either need to move the reference cell each time
or move the offset itself. How can I do this?

 

[Domenic]

Assuming that Sheet1!A1:Z1 contains the data, try...

A1, copied across:

=INDEX('Sheet1'!$A1:$Z1,COLUMNS($A1:A1)*3-3+1)

Adjust the sheet reference and range for your data accordingly.

Hope this helps!

 

[Guest]

Thanks - I was on the wrong track completely!

Assuming that Sheet1!A1:Z1 contains the data, try...

A1, copied across:

=INDEX('Sheet1'!$A1:$Z1,COLUMNS($A1:A1)*3-3+1)

Adjust the sheet reference and range for your data accordingly.

Hope this helps!