Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AJ Perkins, Wales, UK
 
Posts: n/a
Default How do I print a new number on each page

Is there a formula that I can use so that when I print, depending on the
number of copies I do it will add that number.

What I have is a booking form, and each form has to have a new number (eg
A5643, A5644) at the moment I am having to write the number on by hand which
is time consuming when you have over 200 a week to do, so is there a code I
can put in which will automaticly generate a new code when I print,. So if I
have A5643 in, and print out 100 copies, it will automaticly add a new number
to each print.

Thanks in advance for any help!!

AJ
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
why would page 1 of an excel worksheet print smaller of page 2 if. hisdrama pest Excel Discussion (Misc queries) 1 January 10th 05 07:14 PM
Getting rid of 2nd Page on Print. Shadyhosta New Users to Excel 3 December 30th 04 12:36 PM
Page breaks don't show on screen and don't print separately. It i. Peter Excel Discussion (Misc queries) 1 November 29th 04 04:33 PM
how to print a row on the bottom of every page Punx Excel Discussion (Misc queries) 1 November 29th 04 04:20 PM
insert a page number into a cell? Carrmuha Excel Worksheet Functions 2 November 13th 04 07:09 AM


All times are GMT +1. The time now is 02:16 AM.

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"