Try this formula

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

--
HTH

Bob Phillips

"guptasa@gossami .com" <guptasa@gossami
wrote in message ...
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.