Download and examine this file:
http://www.jlathamsite.com/uploads/BUSINESS
_INVOICE11BLANK_WithSemiAutoInvoiceNumberCreating. xls

It is a modification to a template file available from the Microsoft
Templates 'collection' - double-click on the invoice number and it will
increment by one. There is also one macro accessable from Tools | Macros |
Macro to bring up a dialog to let you set/reset your next invoice number.

That should get you started. The rest of your inquiry can probably be
handled by setting up your invoice along with a 'customer database' kind of
setup where when you enter a customer's ID, it places available information
about that customer onto the invoice via VLOOKUP() formulas.

Feel free to contact me at HelpFrom @ Jlathamsite.com (remove spaces) if you
have questions about the customizing of the linked workbook.

There is also some info on methods to do the auto-numbering from J.E.
McGimpsey's site - but I can't locate it right now although I've got some
code and files set up to deal with it in that manner also.
"Pedro AM" wrote:

Hi
I have an issue with regards a function which I believe may be LOOP.
I have an invoice in Excel and I would like the invoice number to increase
by 1 everytime I press a button.
How do I do this?
and then, can I also make it copy into a list details like invoice number,
who to and amount before updating the invoice number, all in one macro
perhaps???

Any help on this would be great , thanks.