Help Need For Creating Invoices In Excel sheet

[Ajayjati25]

Dear Sir

I Have a Fixed Invoice Format In Excel. Invoice No, Invoice Date, Customer Name , Address, item name , rate , Qty and Calculation is Variable. All These details are in other Excel Sheet. Now I Need to Create Thousands of Invoices in Excel. Please Provide me the VBA Code for Creating these Invoices in Seperate sheets.

Sample Invoice and data file is attaching the same.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[Eloise T]

Dear Sir

I Have a Fixed Invoice Format In Excel. Invoice No, Invoice Date, Customer Name , Address, item name , rate , Qty and Calculation is Variable.
Are you referring to the file: EXCEL BILLS -P?
All These details are in other Excel Sheet.
Are you referring to the file: DATE WISE MODAL?

...OR is it the other way around?


Now I Need to Create Thousands of Invoices in Excel. Please Provide me the VBA Code for Creating these Invoices in Separate sheets.
Gleaning your data from "where" to create and append TAX INVOICES in the EXCEL BILL -P, correct?


Sample Invoice and data file is attaching the same.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[Ajayjati25]

Dear Sir

Awaiting for your reply