Hello all,

I need help with multiple voucher printing from excel.

In sheet No.2 I have following data:
In Column A, I have put approx 2000 dates (dd-mm-yyyy).
I have voucher nos in Column B (approx 2000 voucher nos).
In column C, I have different description in each Cell.
IN column D, I have amount of voucher.
In column F, I have name of the person to whom I am paying. This could be few cells.
In column H, I have mentioned the reason for the payment. This also could be few cells as nature of work can be common.

In Sheet No.1 I have format of voucher (A5 size)

I want a vba or a method for printing to PDF/Or printer attached, all the above voucher in the format in Sheet No.1

Sample Data is as follows:

In Cell A1 -> 04 Apr 2017

In Cell B1 -> VCH0005

In Cell C1 -> "Being amount paid to "

In Cell D1 -> 500.00

In Cell F1 -> "Mr. John Doe"

In Cell H1 -> "for carrying goods from our office to some other office"

On the click of a button the above data will be printed in a particular
format which is designed in Sheet1 A5 size or A4 size.

Please help.
Thanks in advance.