On Sat, 29 Jan 2005 22:11:59 -0000, "Ken Wright"
wrote:

And if i read the damn question properly I might even give you the right
answer

=OFFSET(Sheet2!$A$6,,ROW()*6-1)

and copy down

Previous one assumed data was in a column, not a row.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ken Wright" wrote in message
...
Assuming your data starts in A1 on sheet 2 and you want the data from
every
6th row starting row 6 in sheet2, then in sheet 1 in A1 put

=OFFSET(Sheet2!$A$1,ROW()*6-1,)

and copy down

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------

Great! Adjusted it to the following and worked fine.

=OFFSET(SHEET2!$A$6,,(ROW()-6)*6)

Spent hours trying all sorts of fancy things to get this to work
new it could not be that difficult.

Thanks to both you and Max for answers