CREATE AN ACCOUNTING PROGRAM

hello,

I am looking for a way to generate automatic invoices in Excel and divide them by clients

For example:

I have 1000 rows of customers, where 40 orders are from Meghan, 30 for Augusto and the rest from ''x''

First, the program should classify them between ''meghan'' and ''augusto''. Later, the program need to create an automatic invoice to them with all my data

That invoice need to include all meghan's and augusto orders from this month

In the end, we need to generate 1 PDF invoice to each customer, regardless of the orders

Thanks

victor