ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sequential numbering for tickets (https://www.excelbanter.com/excel-discussion-misc-queries/17464-sequential-numbering-tickets.html)

ticketmaker

sequential numbering for tickets
 
I want to make tickets with numbers on them so when I cut them they will be
in order.

Kassie

Type the first number in the appropriate cell, Say C3.

Where the next tickets number must appear, enter the following formula:
=C3+1. Press <Ctrl <V, go to each subsequent cel and press <Ctrl<C to
copy.

You can also use a macro, if you want to print tickets one by one, but maybe
that would be a waste of paper?

"ticketmaker" wrote:

I want to make tickets with numbers on them so when I cut them they will be
in order.



All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com