Print voucher from X to Y

[jp16]

I have attached a simple spreadsheet. I have a tab where i store my data. Another tab is the Voucher and its content is link to Data Tab. Whenever i change the value in B1, the voucher will auto change its content and i will print. Its ok if i print 1 or 2 voucher, but if i print a from 1 to 50, its time consuming coz i need to change B1 and print and repeat the process 50times. Hence i am thinking of having a "From To" where i print 50 voucher in 1 shot without having to print 50times.

[nigelog]

see attached version- you may be able to adapt

[nigelog]

Please Login or Register  to view this content.

[jp16]

Hi, these you guys give are cools! but is there anyway to make it read from Cell B1 to Cell B2 directly then print directly from the range? Because it will be kind of weird if people got to type in the "from" in B1 then key in how many voucher they want to print in the msgbox.

[nigelog]

As far as I can see B1 controls the recipient details. Create a userform with a listbox to select value of B1 and set the number of vouchers in B2. Call the userform instead of the Input box and then call the values from the listboxes rather than the worksheet.

I'll look at later.....

[jp16]

As far as I can see B1 controls the recipient details. Create a userform with a listbox to select value of B1 and set the number of vouchers in B2. Call the userform instead of the Input box and then call the values from the listboxes rather than the worksheet.

I'll look at later.....

Thanks! Will be looking forward to your reply!