Home Creators Posts Import Register Favorites Logout

Videos

Downloads

Content

Hello Members!

In this week’s Feature, Fix, or Focus, we take last week’s Multi-Page Invoices training.

Here's the update I made for this training:

· Print X of Y pages requested by Ian H.

· Center Invoice in page requested by Ian H.

· Email Invoice added by Randy Austin

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Make sure to view the brand new and updated training and download the updated workbook in the attachments below.

Files

Multi-Page_Invoice_Updated

This is "Multi-Page_Invoice_Updated" by Randy Austin on Vimeo, the home for high quality videos and the people who love them.

Comments

Aravind Krishnakumar

wish you added the PageBreak as well the Dim PgBrkQty As HPageBreaks, PgBrk As HPageBreak these are available but not used is it possible to let me know how to add them? i have tried various ways but not getting the right row and sometimes there is additional pagebreak

Excel For Freelancers

HI and thanks, since i did this template a year ago, I do not remember the exact details however if you share screen shots of your issue in our Excel For Freelancers Group (http://bit.ly/groupexcel) We should be able to help with your issue.

Aravind Krishnakumar

Ok thanks randy I totally understand Sorry for the long delay I will try to send the details there.

Johan Kritzinger

How can we add a Statement to the multi-invoice, to send a statement to the customer with all outstanding invoices

Excel For Freelancers

HI and thanks, you can take the original data, run and advanced filter based on the customer name or customer id, and then move those results onto the new sheet and print that. I will try to create a training on that in the future. Thanks very much.

Excel For Freelancers

HI Thomas, I am able to view the video ok in the post above. Can you try another browser or location? Your company or ISP may have a block on these types of videos. I hope this helps and thanks so much.

Joe Amato

In the Invoice sheet, column B, row 9 and below, what do these numbers correspond to? Thank you.