How to do it, and how easy/difficult is to do it, depends on your source data.
when you have a sheet e.g. Invoices, where you have a table with a row for every invoice, and a sheet e.g. InvoiceRows, where you enter every invoice row info as separate row (and then you have a report sheet, where you select an invoice number, and the report is filled with invoice data which you can print out or print to PDF-file), then it is easy. More than that - you can have on sheet Invoices a calculated column which calculates invoice totals from sheet InvoiceRows. And you can have reports to for monthly/yearly sales, or for sales by articles, etc.
when you have a template where you enter certain invoice data in design for printout, and mayby every invoice on separate sheet or as separate file, then it is possible, but I thing the result is not worth the work you will have (not only designing the summary table, but also updating the design continuously).
|