On Tue, 22 Nov 2005 13:23:09 -0800, "Boothie"
wrote:

It might assist if you explain what *you* mean by a Chinese auction.

Rgds

Richard Buttrey
__

Boothie

Do you mean slips of paper with numbers printed upon?

Post back with more detail.


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 13:23:09 -0800, "Boothie"
wrote:

Yes, I need to have 10 squares of each number from 1-200. Buyers will
purchase 10 chances for $1. I know there is an easy way to do this, but
can't remember the formula. Thanks

"Gord Dibben" wrote:

Boothie

Do you mean slips of paper with numbers printed upon?

Post back with more detail.


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 13:23:09 -0800, "Boothie"
wrote:

In a new worksheet.

in A:E1 enter 1 through 5

In A2 enter =A1+6

Drag that across to column E then drag down to row 40.

You now have the numbers 1 to 200

Format for Hozizontal and Vertical centered under FormatCellsAlignment.

Select the 5 columns 40 rows and play with height and width until you get
squares that fit the page. Probably about 50 per page.

Set the Font size to about 36.

Set up your margins top and bottom through FilePage SetupMargins

Print it out and start cutting.


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 15:39:04 -0800, "Boothie"
wrote:

Yes, I need to have 10 squares of each number from 1-200. Buyers will
purchase 10 chances for $1. I know there is an easy way to do this, but
can't remember the formula. Thanks

"Gord Dibben" wrote:

Boothie

Do you mean slips of paper with numbers printed upon?

Post back with more detail.


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 13:23:09 -0800, "Boothie"
wrote: