Help with Offset formula
 

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?

Help with Offset formula
 

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!

In article ,
Ken G. wrote:

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?

Help with Offset formula
 

Thanks - I was on the wrong track completely!

"Domenic" wrote:

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!

In article ,
Ken G. wrote:

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?