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 :)