Hi everyone,

Attached is a workbook containing 3 tabs. The first one cotains a receipt, the second and third contain the details usually printed on the receipt. Now I have 10 suppliers(I only included 2 in my workbook) and I want to be able to generate 10 receipts (in a pdf, word or excel format ) for the 10 suppliers without creating extra sheets/tabs in my workbook. Can someone guide me on how to write VBA to do that?