ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   automatic sequential numbering in excel or word (https://www.excelbanter.com/excel-discussion-misc-queries/3924-automatic-sequential-numbering-excel-word.html)

greg2

automatic sequential numbering in excel or word
 
Would like to set up a template to print tickets and be able to add automatic
sequential numbering

Schuster

This may not be the most sophisticated way, but it will work. Put all of the
ticket information in one cell in an excel worksheet wrapping the text and
putting in spaces to force information to the next line. The ticket number
needs to be the last piece of information. Copy the first ticket to the cell
below and change the ticket number to the next sequential number. Highlight
both cells and drag the lower right hand corner of the hightlighted area down.

"greg2" wrote:

Would like to set up a template to print tickets and be able to add automatic
sequential numbering



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

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