Generate multiple invoices fetching data from rows of a sheet

[devang.vakharia]

Dear Friends,

This forum has came as a wonderful hand of help and I need solution to a problem of mine.

I have a sheet (Annexure 13024) with multiple rows, having information of Invoice No., Invoice Date, VSAT ID, Days etc. In the adjacent sheet the invoice template is attached. The template needs to be populated fetching the data from the rows of Sheet "Annexure 13024" in a way that an invoice is generated for data of each row. I hope I have been able to convey what I exactly want to do. Both the sheets (Annexure and Invoice Template) are in the attached "Test.xlsx"

Would be more than happy to have a solution to this.

Thanks