Progressive number with Excel then print a unique Pdf file
Hi Mark,
Am Fri, 05 Jul 2013 20:38:36 +0200 schrieb Mark:
The content of the label is the same, except that I need to print the
label with a progressive number:
1 of 155
2 of 155
3 of 155
155 of 155
Is there a way with a macro to input the first (1) and last number (155)
and then print a Pdf files with 155 pages?
Then I'll print the Pdf in 4 copies (one each side of the pallet)
click in status bar "Page Layout". If you want the number e.g. top
right click in the right header and then in Header & Footer Tools on
Page Number, then write of and click on Number of Pages.
You can also put it in Footer, left, center or right.
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|