Hi,
I've been using numbers to do my invoicing for a few years now and I think it works well.
I'd like to add a little sophistication to my invoicing system, but I'm not quite sure how to do a couple of things. Here is my setup...
All of my invoices for a given year are in one document. Each invoice is a new sheet in that document.
I'd like to have some automation, where everytime I insert a new sheet (new invoice) it will...
A. Assign the new sheet a new invoice number in a specified cell, that number being one higher than the last invoice number.
B. Add a new line(s) to my master sheet (still in the same doc) with that new invoice number and a couple of other details from the invoice, like total, client name, etc.
If I can just get started with one of these.. I'm sure I can figure out the rest.
Any ideas?
Thanks in advance and happy new year!
Ari
I've been using numbers to do my invoicing for a few years now and I think it works well.
I'd like to add a little sophistication to my invoicing system, but I'm not quite sure how to do a couple of things. Here is my setup...
All of my invoices for a given year are in one document. Each invoice is a new sheet in that document.
I'd like to have some automation, where everytime I insert a new sheet (new invoice) it will...
A. Assign the new sheet a new invoice number in a specified cell, that number being one higher than the last invoice number.
B. Add a new line(s) to my master sheet (still in the same doc) with that new invoice number and a couple of other details from the invoice, like total, client name, etc.
If I can just get started with one of these.. I'm sure I can figure out the rest.
Any ideas?
Thanks in advance and happy new year!
Ari