On the "other" sheet enter this in A1

=OFFSET(Sheet1!$A$1,10*ROW()-10,0)

Drag/copy down as far as you wish.

Will return values from row 1, 11, 21, 31, 41 etc. from Sheet1

Adjust to suit.


Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 15:33:00 -0700, RyanR8881
wrote:

How do I set a formula to choose every "n'th" row and extract it to another
spreadsheet?