• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Macro Modifiy to create Monthly Invoices Customer

Hi,
I have Excel file with Different Sheet ("Dashboard, Invoice") In dashboard Contain Control Button for vba, "Upload file" button to find data file form computer and "Design" button to execute it for filter. Last Button "BreakMyList" have code for making invoice for each customer using Invoice sheet template. vba give error if customer have only one row data, and also i want to make all code small. Help me to if any one know how to do this.

I have attached Main and source file include code that written myself.

After that if possible help to modify invoice other parts like "Customer Name, street Address, Month, Date and Total.
 

Attachments

  • Book5.xlsx
    45.7 KB · Views: 4
  • Create Invoice1.xlsm
    206.1 KB · Views: 3
Back
Top