Not sure, but you could be refering to
something along these lines ..

Assume you have in Sheet1,
cols A and B, data from row2 down

1 11 < in row2
2 22
3 33
4 44
5 55
6 66
7 77
8 88
9 99
10 110
11 121
12 132
etc

In Sheet2
------------
Put in A2:

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

Copy A2 across to B2, fill down until zeros appear, signalling exhaustion of
data from Sheet1

For the sample data in Sheet1, you'll get:

1 11
11 121
etc

which is the data extracted from Sheet1 every 10 rows, commencing with row2

Adapt to suit ..

E.g.: change ROWS($A$1:A1)*10-10
to say: ROWS($A$1:A1)*5-5
if the interval is every 5 rows, instead of 10 rows
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Linking 2 Sheets w/ different formats" <Linking 2 Sheets w/ different
wrote in message
...
I have two sheets that I want to link however the two sheets have
different
formats. Sheet one has data entered every row, but sheet two is required
to
have data entered every 10 rows. If possible, how do I accomplish this?