Hello all

I have a data base with customers and monthly charges. With the help of users here both Everstrive, and Winon they have helped me develop my invoice sheet.
The invoice sheet is designed to have 2 different customers per 1 page to save paper.

I would like to build a macro for a print all invoice to print an invoice per customer. I thought that some how something can be wrote for even customer numbers to be on the bottom invoice and odd customer numbers to be on the top invoice (or vice versa, doesn't matter)
I could do it the long way by clicking recording a macro, and have no problem doing it but I'm sure I will start to run into problems when I add new customers.
I don't quite understand just writing out codes just yet.

Also note that I marked on the invoice sheet where the customer names are placed that are changeable with drop downs (B3, B32)



Test1.xls