What I have:
One “master” excel sheet with invoice information of different organizations: Column A has the number of the invoice, column B the name of the organization, column C the street, Column D the postal code,…
What I want to create, but don’t know how to:
For each row in that excel sheet, I want to create an invoice. I have a template for the invoices. Each invoice should contain the information (address, name, number of invoice,…) of a certain row from my “master” excel sheet. Each invoice should be saved as a excel file, and the file-name should be the number of that invoice.
Is there a way Excel could do this for me, without me creating all the invoices manually? Would be a great timesaver!