selecting every 5th row?

[museumgirl]

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

 

[lenze]

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]

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

 

[penina]

I believe I can write some VBA code for this, but to give you an exact fix I would need more detail. Feel free to Email me at acsadvantage@aol.com

Norman

 

[Yogi Anand]

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
	A	B	C	D
1	1	JohnDoeandCo	JohnDoeandCo
2	2	KaySmithCo	MrExcel
3	3	JaneDoe.	PieterBoekhout
4	4	BobBryer	LaraAnand
5	5	MrExcel	museumgirl
6	6	DaveSpiers
7	7	PamMcNeil
8	8	RegBeasley
9	9	TomHanks
10	10	PieterBoekhout
11	11	FrankYono
12	12	Joe
13	13	Rick
14	14	KaySmithCo
15	15	LaraAnand
16	16	MVP
17	17	BoardMaster
18	18	WallyStreet
19	19	JaneVit
20	20	museumgirl
Sheet10

</SPAN>

Regards!

Yogi