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.

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
"Lostinexcel" wrote:

> 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.