Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kassie
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequential numbering Monique Excel Discussion (Misc queries) 0 March 4th 05 01:01 AM
sequential numbering of pages in a cell John Excel Worksheet Functions 0 February 10th 05 07:01 AM
automatic sequential numbering in excel or word greg2 Excel Discussion (Misc queries) 1 January 15th 05 05:35 PM
How do I set up sequential numbering on labels inventorybrokers Excel Worksheet Functions 3 November 19th 04 04:46 PM
Sequential names on Sequential pages Salt4 Excel Worksheet Functions 2 November 12th 04 04:24 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"