selecting every 5th row?

museumgirl

New Member
Joined
Oct 8, 2002
Messages
1
Hi all-
I have a mailing list of about 1600 names on Excel (from a raiser's edge database). I want to do a samping of these addresses to send out a survey. Is there a way (through a macro?) to pull every 5th record out to produce mailing labels?

thanks you for your help,
abigail
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Maybe try this. Add a temporary column to your table. Format the cells as TEXT. In the first row, enter 1, in the second, enter 2. Use filldown to populat the column. Now do an Auto Filter selecting Custom. CHosse Ends With 0 OR Ends With 5. Copy the filtered list ot a new worksheet.
 

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
Sure there is. I don't do much with Excel's features, I rely upon VBA, which may not be the way to go.

I could imagine a macro "working backwards" from the end of the list. You could position it at the end, it could find it's way to the end.

At that point, the .Row property would be given to the macro, it would Step -5 towards the beginning of the list, all the while transferring every 5th line to a new sheet.

I would hold off on implementing this technique, until the wizards confirm/deny this as the best way to go.

Steve
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
On 2002-10-09 15:58, museumgirl wrote:
Hi all-
I have a mailing list of about 1600 names on Excel (from a raiser's edge database). I want to do a samping of these addresses to send out a survey. Is there a way (through a macro?) to pull every 5th record out to produce mailing labels?

thanks you for your help,
abigail

Hi abigail:

Let us say your address list is in cells B1:B20, then you can do this in the worksheet by writing the following formula in cell C1 and copying it down

=INDEX($B$1:$B$20,(ROW(1:1)*5-5))

See the following worksheet simulation ...
y021009h1.xls
ABCD
11JohnDoeandCoJohnDoeandCo
22KaySmithCoMrExcel
33JaneDoe.PieterBoekhout
44BobBryerLaraAnand
55MrExcelmuseumgirl
66DaveSpiers
77PamMcNeil
88RegBeasley
99TomHanks
1010PieterBoekhout
1111FrankYono
1212Joe
1313Rick
1414KaySmithCo
1515LaraAnand
1616MVP
1717BoardMaster
1818WallyStreet
1919JaneVit
2020museumgirl
Sheet10
</SPAN>

Regards!

Yogi
 

Watch MrExcel Video

Forum statistics

Threads
1,123,316
Messages
5,600,910
Members
414,415
Latest member
joshuaba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top