Numbering Tickets

G

Gord Dibben

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

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
 
Top