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.