Another approach, quite similar to what Gord suggested ..

Assume you have in Sheet1,
data in cols A to C, in row1 down

1 Text1 Data1
2 Text2 Data2
3 Text3 Data3
etc

In Sheet2
-------------
Put in any starting cell, say in A2:

=OFFSET(Sheet1!$A$1,ROWS($A$1:A1)*25-25,COLUMNS($A$1:A1)-1)

Copy A2 across as many cols as there is in Sheet1, i.e. to C2, then fill
down until zeros appear, signalling exhaustion of data extracted from Sheet1

For the sample data, you'll get:

1 Text1 Data1
26 Text26 Data26
51 Text51 Data51
etc

Adapt to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"PC-Nut" wrote in message
...
Hello! I have a list 9000 rows of data and am trying to figure out a way
to
analyze the data in a separate sheet tab by looking at the list of data at
every 25th interval. Is there a Macro or worksheet function that can
automate
the task rather than me typing in the same formulaes 360 times. Thank you