I have created an invoice template. What I’d like to do is create a workbook with the customer’s name. The each worksheet in the workbook would be a separate invoice. How do I insert the invoice template into each now worksheet? Right now I just copy the previous sheet, delete in data, and start over. However, by doing this, I lose my formulas, and have to recreate them. There’s got to be a way to insert/open my invoice template for each worksheet I create in my workbook.
If you have already tried it, create an empty new table.
Just copy the content from a filled table and paste it into the new table?
Does it help you?