Copying a column list from one sheet to another and repeating???

I tried this formula you suggested...

=OFFSET('Sheet1'!$B$11,((MOD(COLUMN(),(COUNTA('She et1'!$B$11:$B$100)))=0)*(COUNTA('Sheet1'!$B$11:$B$ 100)))+(MOD(COLUMN(),(COUNTA('Sheet1'!$B$11:$B$100 )))),0)

But instead of copying from the start of the list at Sheet1 cell B11 it is
starting at cell B13. Also, if I copy the first cell on sheet 2 using this
formula at B10 across the entire row of 30 cells being used it doesn't repeat
the current list of 6 items. There are 14 blank cells, then a cell containing
a 0 then the list starts repeating but from B13 again.

Any ideas why this is or what I am doing wrong?

Thanks

"klswvu" wrote:

=OFFSET('Sheet
1'!$A$2,((MOD(COLUMN(),(COUNTA('Sheet1'!$A$2:$A$10 )))=0)*(COUNTA('Sheet1'!$A$2:$A$10)))+(MOD(COLUMN( ),(COUNTA('Sheet 1'!$A$2:$A$10)))),0)

Explanation:
OFFSET(reference, rows, columns, [height], [width])
returns the cells x rows and y columns from the reference

Reference is an anchor point...
top of your product range $A$2

Determine how many rows down from the reference anchor...
((MOD(COLUMN(),(COUNTA('Sheet1'!$A$2:$A$10)))=0)*( COUNTA('Sheet1'!$A$2:$A$10)))+(MOD(COLUMN(),(COUNT A('Sheet 1'!$A$2:$A$10))))

(MOD(COLUMN(),(COUNTA('Sheet1'!$A$2:$A$10)))=0)
... returns the remainder of the column number by the total count of the
range and determine if it is zero (returns 0 or 1)

*(COUNTA('Sheet1'!$A$2:$A$10))
... multiple by the total count of the range

+(MOD(COLUMN(),(COUNTA('Sheet 1'!$A$2:$A$10)))
... add the count of the range

Assume the range has seven values...
column 1 would result in (0*1)+1 = 1 so go down one row from the reference
anchor
column 2 would result in (0*2)+2 = 2 so go down one row from the reference
anchor
column 3 would result in (0*3)+3 = 3 so go down one row from the reference
anchor
column 4 would result in (0*4)+4 = 4 so go down one row from the reference
anchor
column 5 would result in (0*5)+5 = 5 so go down one row from the reference
anchor
column 6 would result in (0*6)+6 = 6 so go down one row from the reference
anchor
column 7 would result in (1*7)+0 = 7 so go down one row from the reference
anchor
column 8 would result in (0*1)+1 = 1 so go down one row from the reference
anchor

Determine how many columns across from the reference anchor...
,0 ... it is zero