Macro for Multiple Invoice Printing with 1 click (Data Sheet + Print Format Sheet)

[cvishu]

Hi All,

I am facing the problem of generating pdf files of invoices saved in a excel sheet in 1 click.

There are more then 100+ row entry with different data and these are vlookedup in another sheet (invoice format) in the same file.

My trouble is if I have to print all the Invoices, currently I have to change the No of the Invoice (in the format sheet and all the other details are populated by vlookup) then make pdf and then again change the Invoice No and repeat it for each and every invoice.

I believe its something to do with loop or offset but unable to process.

Hope to have quick help from friends here.

Excel attached for your reference.

Reg,
CVishu

[Pradeep13]

I downloaded the workbook. No macro available for multiple printing in one click. Only vlookup formulas.