Want to print Multiple Invioce for One Sheet by single Command

[caanandrai]

Hi

i want to print Multiple Invoices from one template, each having separate invoice no. in cell C6, all the raw date is in other worksheet in the same book.

i have attached the file on which i am working, any help on this is highly appreciated.

thanks in advance

Regds
Anand

[nathansav]

Is a word mail merge using the data as a data source not a better solution?