We need to add 1 to a specific field on every raffle

R

raffle printing

we need to print 1,000 raffles. the ticket number is a three digit i.e 001,
002.

How can we get the number to change for each ticket printed???
 
P

p45cal

raffle said:
we need to print 1,000 raffles. the ticket number is a three digit i.
001,
002.

How can we get the number to change for each ticket printed???

In cell A1 type *1*
In cell A2 type *2*
Select both cells
Click and drag the autofill handle (small square bottom right
downwards until you hit row 999, let go of the mouse button.
Select all 999 cells and in the dropdown menus at the top:
FORMAT|CELLS..
check the *Numbers *tab is visible, then in the *Category *list, selec
*Custom*, then in the *Type *field enter three zeroes thus: *000*
Click OK.


..and if this answer is all wrong, it's because the question was
 
G

Gord Dibben

Are you printing the tickets just through Excel?

Do you have one ticket and print it 1000 times?

Do you have 1000 copies of the ticket on a worksheet and print the
worksheet?

Do you have double-entry tickets...........one for the barrel and a tear-off
for buyer?

Can be done but need to see an example layout.

I would do it all through Word's mailmerge function but post back with some
more info.


Gord Dibben MS Excel MVP

On Sat, 29 Aug 2009 06:56:01 -0700, raffle printing <raffle
 
S

Shane Devenshire

Hi,

Well you certainly didn't give us much info! Suppose the number is in cell
A1 and the ticket is a single spreadsheet range going from A1:D5 which you
want to print 1000 times.

Add the following macro to your workbook:

Sub MyPrint()
For I = 1 To 1000
[A1] = I
[A1:D5].PrintOut
Next I
End Sub


1. To add this code to your file, press Alt+F11,
2. Choose Insert, Module.
3. Paste in or type the code above.
 
S

Sean Timmons

highlight your column, go to Format > Cells > Number tab > Custom
Make the custoemr format 000.

Type in 1, then fill down 1000 times (using the little handle on bottom
right of yoru cell), click the little box on the bottom right, and select
Fill series.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top