A lot of invoices needs be generated

[Raitk]

Hello its seems great commune here.
i have been looking for many solutions and im not good at vba, anyway i have a minute away from banging my head into wall

Anyway my problem is:
i have over 200 clients whos invoices needs to be sent out in every month. is there way to auto generate invoices? Every client has a folder with 20 specialist reports. invoices need to be generated according to specialist reports. Every specialist report has area a9:d31 thats need to be copied in to the invoice.

It all looks like this:
Invoises.xslx
Clients\Client 1\specialist1.xslx
Clients\Client 1\specialist2.xslx
Clients\Client 1\specialist3.xslx
Clients\Client 1\specialist4.xslx
Clients\Client 1\specialist5.xslx
Clients\Client 1\... etc...
Clients\Client 2\specialist1.xslx
Clients\Client 2\specialist2.xslx
Clients\Client 2\specialist3.xslx
Clients\Client 2\specialist4.xslx
Clients\Client 2\specialist5.xslx
Clients\Client 2\... etc...

etc..


is there any way to generate invoices?
I will be very, very, very grateful if anyone can help me ray:

 

[01-7700]

It sounds like you could create a summary workbook for each client and reference the a9:d31 range from each of the specialist workbooks. Or better yet, create one template summary workbook and have input fields to enter the client # which would automatically adjust the formulas that reference the detail specialist workbooks.