create different excel-files with imported values per row

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!

By: Wouter

Leave a Reply

Your email address will not be published. Required fields are marked *