Voucher printing from Excel

[shahidr100]

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.

 

[AliGW]

Cross-posted: https://www.excelforum.com/excel-programming-vba-macros/1180895-voucher-printing-from-excel.html

 

[RedBeard]

May I suggest mail merge?
https://support.office.com/en-us/ar...eadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).

Thank you.