View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark[_71_] Mark[_71_] is offline
external usenet poster
 
Posts: 4
Default Progressive number with Excel then print a unique Pdf file

Hallo to everybody,
I have an Excel file that I use to print a selfadhesive A4 label size to
stich on pallet.

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)

The max number might be different, depending on the project.

I am using Excel 2007 with Microsoft Pdf printer installed.
Thanks and Regards
Mark