Chris
This is pretty simple except for one thing. What constitutes "a new
invoice is generated"? Excel can react automatically to many "events" and
do whatever you want when the "event" occurs. So when do you want the new
number assigned? Maybe when a specific cell gets an entry? Maybe when you
print the invoice? Maybe something else? HTH Otto

"cjw064" wrote in message
...
Hi
Can anybody help me please I have designed an invoice, I want it to assign
a
new invoice number everytime a new invoice is generateded.
Please could somebody give me an answer in clear jargon free wording, as I
am really new to excel and I havent got a clue what I am doing.
Many thanks,
Chris