printing several pages with continuing carton numbers

Hello ,

I have a layout for printing as attached. This is a front carton label. Depends on the carton qty, I need to print many times of those pages whether changing the carton times before every print out.

For instance I print from 1 to 550. Each time I modify the carton numbers and printing it, that means 250 print job!

I want Excel prints all(between) pages with given first and last carton numbers , is there a way to do it?

Try this

Please Login or Register  to view this content.

Hello royUK

Thanks for your quick help. as I'm so newbie on Excel programming, can you tell me where I can write those codes?

Best Regards

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save