I am using Excel 2007. I am trying to copy every 5th row of information and
there is no specific criteria met in each row. Can anyone help?

for i=1 to 25 step 5
rows(i).copy somewhere
next i

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris H" wrote in message
...
I am using Excel 2007. I am trying to copy every 5th row of information
and
there is no specific criteria met in each row. Can anyone help?

Hi,

Assume that your data is in range F8:F18 (including the header row). In
F25, enter =MOD((ROW(F9)-ROW($F$8)),5)=0. In F24, enter condition. Now go
to Data Filter Advanced Filter and in the Action section, select Coy to
another location. In the list box, select F8:F18. In the criteria box,
enter F24:F25 and in the copy to box, select any blank cell. This will copy
every 5th row to a new location.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Chris H" wrote in message
...
I am using Excel 2007. I am trying to copy every 5th row of information
and
there is no specific criteria met in each row. Can anyone help?

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
---
"Chris H" wrote:
I am using Excel 2007. I am trying to copy every 5th row of information and
there is no specific criteria met in each row. Can anyone help?