One other thought ..
Assume your source data in cols A & B
Assume you want to list A1:B1, followed by A6:B6, then A11:B11, and so on
Place in say, E1: =OFFSET(A$1,ROWS($1:1)*5-5,)
Copy E1 to F1, fill down as far as required
Easily adapt the formula to suit:
A$1 = A1 is the offset anchor (ie the top left cell in your source range)
5 = the required interval (every 5th row)
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik