Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,101
Default How do I set up a counter to keep track of prited copies (2 pages.

I have a template to generate batch tickets with batch ticket numbers in a
cell. I like to be able to have a formula that would increase the batch
ticket number by "one" everytime I print a batch ticket. Right now, I start
with a number, print the batch ticket, change the batch ticket number, print
and so on...

Any ideas, any one?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default How do I set up a counter to keep track of prited copies (2 pages.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
David Biddulph

"Mike" wrote in message
...
I have a template to generate batch tickets with batch ticket numbers in a
cell. I like to be able to have a formula that would increase the batch
ticket number by "one" everytime I print a batch ticket. Right now, I
start
with a number, print the batch ticket, change the batch ticket number,
print
and so on...

Any ideas, any one?



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
how insert printed pages counter Kintamasis Excel Worksheet Functions 1 October 14th 07 06:48 PM
"Track Changes" - Prevent turn off track changes to meet SOX regs Tammy Miller Excel Discussion (Misc queries) 2 July 31st 07 11:42 AM
How do I delete pages in Excel? Keeps printing blank pages at end. Jojobean Charts and Charting in Excel 1 May 31st 07 07:37 AM
Some formulas don't track copies, pastes, fill right, fill down whiten Excel Discussion (Misc queries) 2 October 1st 06 04:41 PM
How do I delete pages from an Excell template of mutiple pages pulcom123 Excel Discussion (Misc queries) 2 December 30th 05 04:41 PM


All times are GMT +1. The time now is 02:53 PM.

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

About Us

"It's about Microsoft Excel"