how do I copy specific rows without copying each row individually

C

Chris H

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?
 
A

Ashish Mathur

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top