copy exact values from RangeA to Range B which has extra rows

I have two worksheets 'A' and 'B'.
'A' has 1064 rows of data.
'B' has 7448 rows of data.
I want to reference the data from cells in a column of 'A' to cells in a
similar column in 'B' using a '=' function. the difference is that there is a
gap of six extra rows between the two cells in the second sheet.
I tried to copy and paste down from the first in row 1 (='worksheetA'!B1),
but where I want (=worksheetA'!B2) in Row 7, iI get (='worksheetA'!B7).
Is there an easy way to copy and paste the values or do I have to go through
all of the 1064 references individually?
Thanks for your help.

Try this formula

=IF( MOD(ROW(),6)=1,INDIRECT("Sheet1!A"&INT(ROW()/6)+1),"")

--
HTH

Bob Phillips

"guptasa@gossami .com" <guptasa@gossami [email protected]>
wrote in message news:[email protected]...
> I have two worksheets 'A' and 'B'.
> 'A' has 1064 rows of data.
> 'B' has 7448 rows of data.
> I want to reference the data from cells in a column of 'A' to cells in a
> similar column in 'B' using a '=' function. the difference is that there
is a
> gap of six extra rows between the two cells in the second sheet.
> I tried to copy and paste down from the first in row 1 (='worksheetA'!B1),
> but where I want (=worksheetA'!B2) in Row 7, iI get (='worksheetA'!B7).
> Is there an easy way to copy and paste the values or do I have to go
through
> all of the 1064 references individually?
> Thanks for your help.