sorting out rows
 

I have 1000 rows of data and i want to copy or link every 5th row to another
sheet...
thanks...

sorting out rows
 

Try this:

=INDEX(Sheet1!A:A,5*ROWS($1:1)-5)

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tom" wrote in message
...
I have 1000 rows of data and i want to copy or link every 5th row to
another
sheet...
thanks...

sorting out rows
 

Hi Tom,

Assuming you want rows 5, 10, 15 ... then
1. Suppose the data is in the range J1:J1000 with titles in the first row.
In a blank column, say K, enter the following formula in K2:
=1/MOD(ROW(),5)
and fill it down.
2. Choose Data, Filter, AutoFilter
3. Open the autofilter in K1 and choose #DIV/0!
4. Select the visible cells in column J and copy then to another sheet.

--
Cheers,
Shane Devenshire


"Tom" wrote:

I have 1000 rows of data and i want to copy or link every 5th row to another
sheet...
thanks...