Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an excel sheet to print a set of 4 tickets per page which we use for stock takes.

I found code that prints one number per page. Being a Visual Basic for Applications novice, I was unable to change the code to suit my preferences.

Rather than creating a huge document with 1000 pages for 4000 tickets each with a unique ticket number (starting from 1) I would like to find a macro or function which will print a page with 4 tickets (1,2,3,4) then another page with (5,6,7,8) and so on.

If someone could explain simply how I could achieve this I would be very very grateful :)

share|improve this question
1  
You'd need to maintain the current number scheme as well as the script. My suggestion is to build a script that updates the static cells where these numbers reside, then updates a "hidden" cell with the last number it used, as a place holder for the next time. You'd also need this script to save the document after every print, or else you'll lose all your changes. The alternative is to have your worksheet read/write this info from/to a secondary file. –  CIA Nov 7 '13 at 15:45
    
Do you have any examples of the kind of code I would need to use for any of this? I have never used visual basic to edit macros before and I'm rather unskilled on the programming front! :( –  Danny_UKDM Nov 8 '13 at 8:00
    

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.