creating an invoice
 

It has been a long time since I have used excel. I know that I had a
invoice set up so that each time I opened a new invoice all of my company
info was saved on it and it was in numerical sequence, 101,102,103.....
Can someone please tell me how i did that so I can set it up again. It has
been so long and i have lost my patience and am very frustrated.

--
Message posted via http://www.officekb.com

Naomi, have a look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Naomi Hall via OfficeKB.com" wrote in message
...
It has been a long time since I have used excel. I know that I had a
invoice set up so that each time I opened a new invoice all of my company
info was saved on it and it was in numerical sequence, 101,102,103.....
Can someone please tell me how i did that so I can set it up again. It has
been so long and i have lost my patience and am very frustrated.

--
Message posted via http://www.officekb.com

Naomi

What are you looking for?

An invoice template or the sequential numbers?

The Template should be under FileNew...TemplatesSpreadsheet Solutions.

You will need the TMPLTNUM.XLA in your Office Library.

If don't have TMPLTNUM.XLA(2002 and 2003 don't have it with their invoices).

For the sequential numbers see JE McGimpsey's site.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben Excel MVP

On Mon, 21 Mar 2005 21:07:39 GMT, "Naomi Hall via OfficeKB.com"
wrote:

It has been a long time since I have used excel. I know that I had a
invoice set up so that each time I opened a new invoice all of my company
info was saved on it and it was in numerical sequence, 101,102,103.....
Can someone please tell me how i did that so I can set it up again. It has
been so long and i have lost my patience and am very frustrated.