In traditional spreadsheets, the semantic value of the numbers is lost. The number in cell B2 is not “the number of cars sold in the month of January”, but simply “the value in cell B2”. The formula for calculating the average is based on the manipulation of the cells, in the form =C2/B2. As the spreadsheet is unaware of the user’s desire for D to be an output column, the user copies that formula into all of the cells in D. However, as the formula refers to data on different rows, it must be modified as it is copied into the cells in D, changing it to refer to the correct row. For instance, the formula in D4 would read =C4/B4. Excel automates this later task by using a relative referencing system that works as long as the cells retain their location relative to the formula. However, this system requires Excel to track any changes to the layout of the sheet and adjust the formulas, a process that is far from foolproof.[8]
Another fan of Fusion Pro Desktop here. This is exactly what you need. We have sold both PrintShop Mail and Fusion Pro Desktop for this very application (numbering) and other VDP applications. Fusion Pro Desktop easily beats PrintShop Mail from both a price and performance viewpoint. You could also try Printer's Bench http://www.elkriversystems.com/ProductsList.aspx for a good entry level package

10 Pt. Cast Coat, C1S 80 Lb. Smooth Cover 67 Lb. Bristol Cover 65 Lb. TimberLine Cover 10 Pt. Hot Stock 13 Pt. Tag Stock 24 Lb. Bond 80 Lb. Digital Gloss Cover 80 Lb. Digital Matte Cover 90 Lb. Index 10 Pt. Manilla 110 Lb. Index 100 Lb. Gloss Text 11 Pt. Cast Coat, C1S 12 Pt. Smooth Cover 12 Pt. Cast Coat, C1S 2 Part Carbonless
We have a 700. In Indesign I design raffle tickets 5 up. You have to create an excel file with your numbering 5 up or 5 columns, save as a text file. Use your data merge in Indesign. If your file is too large your Indesign will crash. So keep the placement of your number and delete all other copy on the page. Then do a data merge. It will create just the numbered pages. Send that to your Fierty command workstation as process and hold. Go back and send original file with just your copy layout as a process and hold job. In your command workstation open copy file
Hello Bruce, I seem to be having a different problem altogether. I created my ticket in word using logos and text boxes as needed, ticket looks great. I followed your very clear instructions but when I did the Finish & Merge I got this message, "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I then click on OK and get this, "A field calculation error occurred in record 1. Bruce any help would be much appreciated. Thank you!!

Thank you for these instructions!! I'm using them to auto number my son's baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I'm using Word on a PC. Thanks!!
The exciting thing about our templates is that you are free to customize them, they are easy to download, and you can use them over and over again. These templates will save you time and money and so easy to use, that you can grab yourself a cup of coffee, sit down, relax and create your raffle tickets. Remember you might find other uses for them as well, some may use this sequential numbering system to create price tags for bake sales, and garage sales. Indeed, anything you may require a ‘ticket’ for, you can customize our templates and make them work for you.
The event will set up certain prizes. Raffle tickets are then sold, and the people told to hold them until the raffle is held. Raffle tickets are then drawn randomly, and the holders of the winning tickets get a prize. While organizers can be as creative as they wish, offering bulk purchases of tickets and discounts, the basic rules stay the same. The benefit of holding raffles is that donors enjoy the anticipation of possibly winning a prize, while donating to a charity. This makes raffle tickets one of the most popular ways to earn for a nonprofit.
I came across this website that explained how to do it using Microsoft's "Raffle Ticket" template (https://www.techwalla.com/articles/how-to-create-numbered-tickets-in-word). However, when I tried to update the sequences as the article said, I could not find the option to update the field (I think they were referring to the option "edit field"), after copying and pasting the template onto a second page.
Hello Bruce, I seem to be having a different problem altogether. I created my ticket in word using logos and text boxes as needed, ticket looks great. I followed your very clear instructions but when I did the Finish & Merge I got this message, "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I then click on OK and get this, "A field calculation error occurred in record 1. Bruce any help would be much appreciated. Thank you!!
×