My wife is attempting to make an invoice template for her business.
She would like each customer file to have a "Front Page," with customer information, and specifically a section dedicated to invoice history. Ideally, each time a new invoice is added into the workbook, she would like a new row to be automatically filled in the invoice history, with the invoice number, date of invoice sent, and other key information.
These invoices will be copied from a template that will have the same information in the exact same place every time, so hopefully there is a way to easily do this.
If this explanation didn't provide enough information, please let me know, and I'll try to provide any additional information I can.
Thank you very much in advance to anyone who looks into this!