Update - Each printout now contains 6 tickets with the numbers 1-90
randomly placed, but in such a way that each column contains the
correct numbers for example, column 1 has the number 1-9 randomly
distributed, column 2 has the number 10-19 randomly distributed etc.
Each ticket contains 15 numbers. Each ticket is 9cells by 3cells. The
macro generates the random placment and then prints 1 sheet - simply
run the macro each time you want a new sheet. The form is unlocked, so
you can check out and edit it in any way you want.

James


wrote:
Hi Bob,
I was looking for a similar solution recently but ended up designing my
own. It's a UK style Bingo Sheet designed in Excel 03, and has 6
tickets per page, each ticket measures 9x6 cells, and spread randomly
across all 6 tickets are the numbers 1-90. I've designed a macro to
generate a single 6 ticket sheet and print it, so you just need to run
the macro for however many sheets you need - HOWEVER - I haven't yet
figured out how to evenly distribute the numbers 1-90 so that there are
exaclty 15 numbers per ticket, but it's a good start anyway. If you
want a copy, send me an email darklordateclipsedotcodotukNOSPAM (change
at to @, dot to . and remove NOSPAM from the end)