Printing Sequential Numbers

[tinkylover87]

I'm trying to create an invoice-like document that shows "Ticket" numbers in the upper-right hand corner where every time I open it, it shows the last printed number in a cell. Then when I go to print it, I'd like to be able to print the next 50 pages, each showing a ticket# one more than the previous. I've come across multiple different macros to try and none of them have worked. I'm using Excel 2010. Please help!

[JOHN H. DAVIS]

Welcome to the Forum. Can you attach a sample with your layout? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[tinkylover87]

Here is a partial example of the document I'm trying to create. Basically, in cell G1, I want to be able to click on print and 20 pages will automatically print, each one with a number 1 more than the last. Then the next time I go into the document, I want to be able to choose to start with a certain number in that cell.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.