I need to invoice someone each week. I would like to create a template as 90% of the information on each invoice is the same, and the remaining 10% follows simple rules.
Each invoice has a number that is 1 more than the previous one. So in Excel is there a way that I could have it auto-increment between instances of the template? For example if the last template had the value 1 for the invoice section, how can the next automatically be 2?
Also how can dates be increased by 7 days?
I'm thinking that a template could somehow remember the previous one and then open it up with the updated information and save it under a new name.