I'm looking in ways of making PDFs of a single page of Excel, whose content changes dynamically depending on a variable. I can't imagine I'm the first looking for this, but I couldn't find any information...
More concretely, let's say I have a huge table where I put in details of an order of a client (personal information, what he has ordered, how many, costs, etc.). On a different page I have a nicely formatted invoice, which I want to export to a PDF to send to the client. I just fill in the InvoiceID and the whole page is ready for export.
However, let's say I need to do this weekly for hundreds of invoices. This means that I need to start with InvoiceID_000, export to PDF, change the corresponding cell to InvoiceID_001, export to PDF, change the cell InvoiceID_002, export to PDF, etc. A lot of work. So I'd need something that can loop through all InvoiceIDs and export the page per InvoiceID.
I'd say something like:
Is this doable? Can someone guide me in the right direction? I have no experience with VBA, but I'm sufficiently experienced with mathematical programming and the "normal" Excel functions. Thanks!![]()
Please Login or Register to view this content.
Bookmarks