Macros Print multiple invoice Generator 2 different customers per single page Odd/Even num

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

Hi,

Do you want to print all invoices or just those that have a charge pending, which I am assuming are those in red under she sheet Sum

Thanks

Thanks for the reply

I would like to just keep it simple and print all, 9 out of 10 times they all will owe when invoices are generated.

also note on sum sheet text in red auto go to invoice sheet

Thanks for taking the time to help

Hi,

Perhaps something like this.

Please Login or Register  to view this content.

Also I did not realized that you wanted to print with a button so I made some changes to the Sheet_Change event. You can keep them or dispose them.

Please Login or Register  to view this content.

And this is a sample of the file Test1 (1).xls

Thanks

PS: You should include a link to your previous post where other people helped you as a reference.

Here is the links to the help I received
Everstrive - http://www.excelforum.com/excel-prog...ml#post3520921

Winon - http://www.excelforum.com/excel-prog...ml#post3523320

Also a big thanks to yourself Fredlo2010

This is a great web site that has been a Huge amount of help to me!

I am glad I was able to help

If you are satisfied with my answer please do not forget to click the * to give me a rating.

I would be glad to give you a rating and thanks again