Need help in making my invoices auto count

[Lostinexcel]

I need to find out how to make my invoices increase by 1 digit every time i
copy/create a new invoice. I also would like to find out how i can make my
totals (ie..for tax, and sales) get directed into a new spreadsheet
displaying the date the invoice was created and giving a running total for
the month and year. Is this possible or am i way out to lunch on this.

 

[FloMM2]

Lostinexcel,
Have you checked out MicroSoft's free templates?
at: http://office.microsoft.com/en-us/templates/default.aspx
You can search for "Invoices" there. Depending on whether you are using
2003, 2007 or any other version of Excel.
You could download the file and see how the invoice number is generated.
hth