Print consecutive numbers

**shootertec** · 10-12-2009, 04:22 PM

Hello, I am in need of some help.

I have an excel sheet with two pages, one renamed "Info" and page two named "Print."
Info page is the changed info from job to job, the print page has it formatted and ready to print.

Now, all I need is to print 50 sheets of the same identical page...all except for cell number E4, which will count consecutively 1 thru 50 during the printing process – it is not required in the excel sheet itself.

Can this be done without having to physically make 50 pages and numbering them? Thanks for the help – TGFF!

**JBeaucaire** · 10-12-2009, 04:42 PM

If E4 is part of the printed range, then this will do it:

Please Login or Register  to view this content.

This version will ask you for how many copies:

Please Login or Register  to view this content.

**shootertec** · 10-12-2009, 05:05 PM

Is their a link or something that explains how to use such a code?

**shootertec** · 10-12-2009, 05:25 PM

Okay, I figured out how to run the macro and it worked.

However it sent the print job to our office printer as 50 print jobs and took forever to print them all out. I thought I would have it save the file as a PDF then print (hardcopy) the complete file. However the error in my logic was that it would be 50 files.

So is their any other way to create the same results but print the job in a more efficient single job.

Thanks again!

**JBeaucaire** · 10-12-2009, 05:27 PM

You said you didn't want to have 50 sheets, so in that case, I don't believe so.

**shootertec** · 10-12-2009, 05:46 PM

Oh well, that is to bad.

At least I can print off manifests with typed in consecutive numbers now and they will at least look a lot more professional. Just wish I could figure out a way to make it with just one file and one print job.

I appreciate the other code for the x value print. Each job and quanity of needed manifests is different.

**JBeaucaire** · 10-12-2009, 05:48 PM

Originally Posted by shootertec

I appreciate the other code for the x value print. Each job and quanity of needed manifests is different.

I thought that might be the case...

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)