Hello Friends,
I was searching thread for PDF print macro with n number of prints with changes in cell value each time. But couldn't found it.
I have file with 2 sheets. First Sheet is with all details of Invoice up to specific no. of rows.
And second sheet is with Invoice Format.
Want to VBA code for below conditions.
1) Each invoice should be printed in PDF format with change in specific cell value with +1 mainly in invoice number as per Sheet 1 (2001, 2002, 2003 ... ). And save with "Invoice No." as file name.
2) Invoice should be printed only if Grand Total of Invoice in Sheet 2 is positive.
3) It should print repeat VBA code at X number mentioned in Sheet 2 in specific cell. ( I will take Count of Total No. of Invoices as per Sheet 1).
Hope I have wrote clearly.
I was searching thread for PDF print macro with n number of prints with changes in cell value each time. But couldn't found it.
I have file with 2 sheets. First Sheet is with all details of Invoice up to specific no. of rows.
And second sheet is with Invoice Format.
Want to VBA code for below conditions.
1) Each invoice should be printed in PDF format with change in specific cell value with +1 mainly in invoice number as per Sheet 1 (2001, 2002, 2003 ... ). And save with "Invoice No." as file name.
2) Invoice should be printed only if Grand Total of Invoice in Sheet 2 is positive.
3) It should print repeat VBA code at X number mentioned in Sheet 2 in specific cell. ( I will take Count of Total No. of Invoices as per Sheet 1).
Hope I have wrote clearly.