creating an invoice

[Naomi Hall via OfficeKB.com]

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.

 

[Paul B]

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

 

[Gord Dibben]

Naomi

What are you looking for?

An invoice template or the sequential numbers?

The Template should be under File>New...Templates>Spreadsheet 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