Every 7 rows, starting at A1 would be:
A1, A8, A15, A22 ... etc.

Enter this *anywhere*, and copy down:

=INDEX(Sheet1!A:A,7*ROWS($1:1)-6)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Guido Cole" wrote in message
...
Excel 2003
Sheet 1: I have data in A1, A2, A3,A4,A5 ... A365
On Sheet 2, I need to copy the data from every 7th row on sheet 1 and
would
like to do this with autofill.

I would appreciate any help.
--
Guido