One way:

Column 1: =INDEX(Sheet1!$F:$F,(COLUMN()-1)*7+4)

Copy across...

In article ,
mattblack wrote:

I want to take some values off one worksheet and put them in a table on
another worksheet.

The issue is that the source numbers are in the same row but 7 columns apart.

I want to put them into columns next to each other on another worksheet by
filling the formula accross the columns.

ie col 1 col 2 col 3
etc
= 'sheet 1'!F4 ='sheet 1'!F11 ='sheet 1'!F18

Is this possible or do I have to manually change the cell references.
I am using Excel 2002.
Cheers