Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I create a sample in Excel?
I am trying to create a sample, needing every 20th record out of around 3000
records. |
#2
|
|||
|
|||
Mary,
You need a VBA procedure. Sub AAA() Dim RowNdx As Long Dim DestRng As Range Set DestRng = Worksheets("Sheet2").Range("A1") For RowNdx = 1 To 3000 Step 20 Rows(RowNdx).Copy Destination:=DestRng Set DestRng = DestRng(2, 1) Next RowNdx End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mary" wrote in message ... I am trying to create a sample, needing every 20th record out of around 3000 records. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a macro, that references another excel file ??? | Excel Worksheet Functions | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
create price list from excel sheet | Excel Discussion (Misc queries) | |||
how do I create qif files from Excel for import into Quicken? | Excel Discussion (Misc queries) |