Numbering Tickets
 

How do I number tickets in sequence using excel.

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

On Sun, 13 Feb 2005 11:25:01 -0800, "Chuck"
wrote:

How do I number tickets in sequence using excel.

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

--
Regards,
Tom Ogilvy


"Chuck" wrote in message
...
How do I number tickets in sequence using excel.