G Gord Dibben Feb 13, 2005 #2 Chuck That would all depend upon how your ticket data is laid out and you give very little detail. I do up a lot of numbered tickets for a couple of associations I belong to. I set up my data in Excel with a column for numbers then I use Word Mailmerge to print the tickets. Printing labels or tickets from Excel is trial and error. Word does a fine job because it is designed for that type of operation. Gord Dibben Excel MVP
Chuck That would all depend upon how your ticket data is laid out and you give very little detail. I do up a lot of numbered tickets for a couple of associations I belong to. I set up my data in Excel with a column for numbers then I use Word Mailmerge to print the tickets. Printing labels or tickets from Excel is trial and error. Word does a fine job because it is designed for that type of operation. Gord Dibben Excel MVP
T Tom Ogilvy Feb 13, 2005 #3 assume you have 1 in cell a1 and you want your second ticket number in cell A6. In A1 put in =A1+1 then select the cells that make up your second ticked and do edit =>copy then select a range below that will hold an integer number of tickets and do Edit=>Paste An alternative would be a macro Sub NumberTickets() Dim i as Long, j as long j = 0 for i = 1 to 300 step 5 cells(i,1).Value = J + 1 j = j + 1 Next end Sub
assume you have 1 in cell a1 and you want your second ticket number in cell A6. In A1 put in =A1+1 then select the cells that make up your second ticked and do edit =>copy then select a range below that will hold an integer number of tickets and do Edit=>Paste An alternative would be a macro Sub NumberTickets() Dim i as Long, j as long j = 0 for i = 1 to 300 step 5 cells(i,1).Value = J + 1 j = j + 1 Next end Sub
