selecting every fifth row of large spreadsheet

[Redman7x]

I have a large spreadsheet, 32,000 rows X 13 columns and I need to create graphs of the data but 32000 data points is too many. I need to select every fifth or Nth row and copy it to another sheet. I think a macro would work, but i don't know how to write them. Can anyone please help me???

 

[Gerald Higgins]

Here's a possible formula solution.
Insert a helper column somewhere, let's say it's Col A.

Let's say your data is in the range from B2 downwards and to the right.
In A1, input 5, or whatever N is.
In A2, put this formula

=if(mod(row()-1,a$1)=0,1,0)

This will put a 0 on all rows, except the Nth rows, which will have a 1.
Then use Data Filter to select these rows, and copy them across.

Once you've done this, you can easily record a macro while you do it.

 

[gauntletxg]

=OFFSET(Sheet1!$A$1,ROW()*5,0)

You could also use this in your destination sheet. Change the sheet name, and fill across/down.

If you really wanted to use code this should work

Dim i As Long
For i = 1 To Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp) Step 5
    Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).EntireRow.Value = Sheets("Sheet1").Rows(i).Value
Next i

But both formula approaches will probably be more flexible for you if you need to make changes in the future.

 

[Gerald Higgins]

gauntletxg's formula solution is probably better than mine - it doesn't need the DATA FILTER stage.

 

[tusharm]

See (and adapt as needed)
Select Markers
http://www.tushar-mehta.com/excel/newsgroups/only_some_markers/index.html

I have a large spreadsheet, 32,000 rows X 13 columns and I need to create graphs of the data but 32000 data points is too many. I need to select every fifth or Nth row and copy it to another sheet. I think a macro would work, but i don't know how to write them. Can anyone please help me???