Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
We need to add 1 to a specific field on every raffle
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??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
We need to add 1 to a specific field on every raffle
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 wrote: 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??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
We need to add 1 to a specific field on every raffle
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "raffle printing" wrote: 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??? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
We need to add 1 to a specific field on every raffle
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. "raffle printing" wrote: 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data based on specific field | Excel Worksheet Functions | |||
empty values for a specific field | Excel Discussion (Misc queries) | |||
Summarizing field quantities for specific records | Excel Worksheet Functions | |||
How do I count a value if another field = a specific value? Excel | Excel Worksheet Functions | |||
How do I select only specific parts of one field? | Excel Worksheet Functions |