Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Numbering Tickets
How do I number tickets in sequence using excel.
|
#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 On Sun, 13 Feb 2005 11:25:01 -0800, "Chuck" wrote: How do I number tickets in sequence using excel. |
#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 -- Regards, Tom Ogilvy "Chuck" wrote in message ... How do I number tickets in sequence using excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel numbering add-in | Excel Discussion (Misc queries) | |||
automatic sequential numbering in excel or word | Excel Discussion (Misc queries) | |||
Page Numbering | Excel Discussion (Misc queries) | |||
How can I create consecutivlely numbered tickets? | Excel Worksheet Functions | |||
excel 2003 page numbering | Excel Worksheet Functions |